Dear Experts,
I am looking for some help with copying and pasting dynamic range but being new user of VBA I am not able to define it correctly.
Purpose of the code is to copy and paste from the values shown in
1. Cell B1 (Drop Down List of item name)
2. Cell A2 (Defines the row to start from with a Match formula and picks up first occurrence of the item name)
3. Cell A3(Counts the number of times item name occurs in column and data is sorted)
4. Data table is from AD1 to AP578 (Can be moved to new sheet if required it will be hidden)
What I am trying to achieve is to be able to copy starting from Column AD row 506(506 is the value in B1 using match formula) and copy 61 row (Value in A3 from Count Formula). Copy all 13 Columns and paste in cell A7. It should also change/auto update with change in B1
In other words I want to copy
Row(Value in A2) column AD through to Row(A2+(A3-1)) Column AP
And paste it in A7 and update it every time dropdown in B1 changes value in A2 and A3
Thanks in advance/VKS
Bookmarks