Good Morning good people,
I'm wondering if anyone can help.
I would like to loop through xlsm files opening them (looping until the date of the file equals the actual date or time) copying specific data then format, order and paste the consolidated data from the files into the master book then close and not save the opened books ,
the code would need to find the last cell then tab so all the formatting from the cells above are copied down before pasting the consolidated data.
sounds easy
I'm wondering if anyone can help.
I would like to loop through xlsm files opening them (looping until the date of the file equals the actual date or time) copying specific data then format, order and paste the consolidated data from the files into the master book then close and not save the opened books ,
the code would need to find the last cell then tab so all the formatting from the cells above are copied down before pasting the consolidated data.
sounds easy