Matching Dates Across Workbooks

[jamie1985]

Hello,

This is my first post and I am not too good with VBA, so please bear with me. I've been stuck with this problem for a while and after lots of searching simply cannot find anything on it.

In short I am trying to create a file that will pull data from another file at regular periods, so I need to paste the data from the update file into the main file. The problem is that the update file does not just contain the new data, it contains all data from the beginning of the year, and the main file contains 10 years of data. So I need to ensure that only the new data is added to the main file (copied and pasted across).

The way I have been trying to do this is to simply select the first data from the update file (so currently 01/01/2014), find this in the main file and paste the entire contents of the update file from there down (so overwriting the duplicate data).

I have been looking at the FIND and MATCH functions and they both work until I introduce the variable which finds the date from the update file (I hope that makes sense....)

Here is an example of something I have tried (I have only tried it within one workbook at the moment for simplicity):

Please Login or Register  to view this content.

The copy and paste part is not here as I am stuck at the point of locating the correct cell in the main workbook. I use MsgBox just to see if it has worked.

If I replace 'RFStart' in the find function with an actual date (or a word) it works. But when attempting to use the RFStart variable I get various errors whatever I try.

Any help would be great.

Thanks

[jamie1985]

Can anybody help please...?

I realise I probably haven't specified everything in the correct way but the problem I am having only relates specifically to using the RFStart variable in the Find function. Does anybody know if it's just not possible to do this?

Thanks

[Fotis1991]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.

[adyteo]

sorry Fottis, we probably posted the same time.

[jamie1985]

Sorry, I've added the tags now.

Thanks

[adyteo]

Before Set rngRFPaste you should make active your worksheet where you try to find RFStart. E.g sheet("name").activate

[jamie1985]

Thanks