Hello,
How can one accomplish to have a DropBox With a list of, lets say 50 items and Next to it an empty field (for example C13:K41) and for each item that is chosen in the DropBox there should be copy pasted the corresponding line (from the data area lets say JW1:KE50) With information into the first empty row within C13:K41.
In a row in the data area JW1:KE50 for example JW1:KE50 the cell JV1 contains one of the values from the DropBox list. And the DropBox list is mentioned in AA1:AA50.
Now I know one way of doing this With the following code, but writing this for each and every possible value is huge job. (The actual data amount in question is about 1000):
Anybody know how to do this a lot smarter?
The Logic I´m thinking about is something like If the DropBox value is Equal one of the listed items in the range JV1:JV50 Then OFFSET Row 1, 2, 3, 4, 5, 6, 7, 8 and 9 and then copypaste these into first available row in the C13:K13 field.
Anybody know a smart code for this so that it will search for the correct cells to copy paste instead of having me writing more than 1000 of the same code over and over again?
Thanx in advance
Bookmarks