Copy Paste Row from one workshhet to Another

Experts, I need help in VBA.

I have a bunch of spreadsheets, that I need to copy ONE row data and paste it into another spreadsheet with out opening them. Filed name is same in all.

My Idea would be: place a button in blank sheet and write VBA behind it. There will be a source folder holds all source files and Destination folder createds new files with the copied row in them.

For example: source folder will have the following files with field name: "Inv_Number". Code should copy this filed and create another book in the destination folder named as Book1_Inv_Number like that.

C:\Source Folder: C:\Destination Folder
Book1 Book1_InvNumber
Book2 Book2_InvNumber
Book3 Book3_InvNumber
Book4 Book4_InvNumber
Book5 Book5_InvNumber

I am not a savvy in excel. Kinda button pusher. Really appreciate experts help.

Thank you.

No replies