|
#1
|
|||
|
|||
Drag and Drop from fields and nummering?
Hello all
I am stuck, I need some help please. I would like to build in some automatism for my process. created this document. I have some difficulties with the automation of the consecutive numbering, as a formula as well as text. For example, if I select the fields "H4-H11" and then drag them down the logical sequential numbering does not match the numbering in the with this in the document. From an Excel logic perspective I have to agree with the numbering of the fields, but I need them need it numbered accordingly as I know it from 1-49. I have an identical problem in rows "A8-A10". I have created the first three lines "manually", hoping that the numbering numbering from the pattern with the drag down automatically. =TEXTKETTE("int"&B2&"01") <<-- Created manually =TEXTKETTE("int"&B2&"02") <<-- Created manually =TEXTKETTE("int "&B2& "03") <<-- Manually created, selected and dragged down 3 fields. =TEXTKETTE("int"&B5&"01") <<-- Why is line B5 and the numbering starts again at 1? =TEXTKETTE("int"&B5& "02") =TEXTKETTE("int "&B5& "03") Thanks and Greetings M |
#2
|
||||
|
||||
Please post a sample sheet ( no pics please). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
sorry this post was a wrong post, if you will go to the right post, please follow this Link: --> https://www.msofficeforums.com/excel...-counting.html
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
automating drag & drop | rob171171 | Excel | 9 | 04-23-2016 07:09 AM |
Drag & Drop between fields is sketchy? | johnlondon | Outlook | 1 | 03-26-2014 03:31 AM |
Drag and drop macro | Amanoo | PowerPoint | 2 | 06-15-2012 04:01 AM |
Drop and drag macro | Jamtart | PowerPoint | 3 | 04-15-2012 11:05 PM |
Drag & Drop problem | nickywave | Outlook | 0 | 04-12-2011 01:40 AM |