Originally Posted by
fixer
we have to Open all the files all files are closed except the vba placed file
If column E of school.xlsx matches with column A of school2.xlsx then copy column E of school2.xslx and paste it to column Z of school1.xlsx and save and close all the files(close school1.xlsx and close school2.xlsx)
macro will be attached to a different file
all files are located in same place
example
cell E20 of school1.xlsx matches with column A10 of school2.xlsx then copy E10 of school2.xlsx and paste it to Z20 of school1.xlsx
Plz have a look i have attached my sample file also
Posting Permissions
Reply With Quote
Bookmarks