Copy Paste Value Macro

[SESTEN]

Hi Everyone,

First timeposter, looking for some help as i’m just beginning with Macros.

What i’m looking to do is the following

1) find the last date and time listed from.the one file (lets call it Workbook 1)
2) go to the other work book (Lets call it workbook 2), find that date and time from Workbook 1 in it,
3) copy all the date and times in workbook 2 and the data associated w/ it
4) paste them as values into Workbook 1, below the data already existant on it (below the last time we found).

Would anyone have any ideas what the easiest way would be goingabout this? It is critical i post as values, as Workbook 2 has formulas dependant on other files.

Thanks a lot in advanced!

[FDibbins]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
https://www.excelforum.com/excel-pro...lue-macro.html

Thread Closed.