Hi All,
I want to add new workbook with paste specfic column header data.
Destination: Order date, Region, Item & Unit cost
Source file: Order date, Region, Rep, Item, Units & Unit cost
Hi All,
I want to add new workbook with paste specfic column header data.
Destination: Order date, Region, Item & Unit cost
Source file: Order date, Region, Rep, Item, Units & Unit cost
Hi Jagadeesan,
Even though you haven't provided the additional details asked for, I played around with this just for fun. (there are elements in the code which I will find helpful with future projects) The macro code as written only works on my machine, so you will need to edit the code to match your situation. (file is attached)
I came up with 4 different methods:
1) copy the existing file and then delete the unwanted columns
2) create a new workbook and copy the desired data to the new workbook
3) copy the desired data to an existing workbook and overwrite the existing data
4) copy the desired data to an existing workbook and add it below the existing data
If you (or someone you know) is familiar with VBA, modifying the coode should be easy.
If you find this solves your dilemma please mark my answer as selected.
Cheers :-)