Copy paste the required column data to new wb from filtered data in the other wb

Hi,

In the following code, I need some help to copy and paste the data from the required column to a NewWorkbook and save it in a particular folder I have chosen initially.

Source File = Salary File
NewWorkbook = OutputFile

After opening source workbook which I've chosen and has full data, I've filtered the data with multiple conditions. Now after filtering the data select the particular columns (say for example column B, AG, AI & AJ) then paste the selected column data in text format in a new work book coloumns in the same order (Say G, F, H & I). Means B data from source file to new workbook G column, AG data to F, AI to H & AJ to I. After this i want to save the new work book in the same folder from which i've chosen the source file. Here while chosing the data from source file firtst row should be ignored which has all the header titles. and paste the data to new workbook in order and save in the same folder whre source file is located and finally exit the source file without saving it.

Please help me with this.

Please Login or Register  to view this content.

Hi,

Can anyone please look into this and help me out with this.

Originally Posted by Vcare

Hi,

In the following code, I need some help to copy and paste the data from the required columns to a new workbook and save it in a particular folder I have chosen initially.

Source File = Salary File
NewWorkbook = OutputFile

After opening source workbook which I've chosen and has full data, I've filtered the data with multiple conditions. Now after filtering the data select the particular columns (say for example column B, AG, AI & AJ) then paste the selected column data in text format in a new work book coloumns in the same order (Say G, F, H & I). Means B data from source file to new workbook G column, AG data to F, AI to H & AJ to I. After this i want to save the new work book in the same folder from which i've chosen the source file. Here while chosing the data from source file firtst row should be ignored which has all the header titles. and paste the data to new workbook in order and save in the same folder whre source file is located and finally exit the source file without saving it.

Please help me with this.

Please Login or Register  to view this content.