Hi All,
Appreciate all your help in getting below assistance.
I have a sheet with data in some columns however I want to copy data from only specific columns and paste to a new sheet using VBA
For instance, I want to copy data from columns F:G(5 columns) from my datasheet to a new sheet in A:E(5 columns) and go back to my datasheet and copy data from M:Q(5 columns) and move to newly created sheet and paste data in column A:E(5 columns) and not in first row but in first blank row after my first set of data from datasheet and again go back to my datasheet and copy T:X(5 columns) and move to newly created sheet and paste data in column A:E(5 columns) and not in first row but in first blank row after my second set of data from datasheet.
So in short I have a set of 5 columns data 3 times in my data sheet and I am trying to move all data into one set in a new sheet one after other.
And number of rows in set might differ too.
I did see some similar question and solutions however they were trying to copy and paste only one column and my problem is not one column but set of 5 columns....I tried to tweek the provided solutions but no luck.
Time in assisting is much appreciated please..
Bookmarks