Hi,
I'm trying to write a macro but having a little trouble...
I would like to look at each cell in Column B (worksheet "master") and set this as a variable called "currentaccount"... i would then like to go to a sheet called "data" and find the "currentaccount" variable in Column A, select the entire row the copy and paste the entire row to a new workbook called "currentaccount". Then repeat this entire process until all accounts listed in column B, master worksheet have had a file created.
Hope that makes sence
Thanks
Bookmarks