Need help with VBA to copy values only to a specific date in a grid

Hi there

I have little to no experience with VBA and am struggling to get my head around it and hope someone is able to assist with the following

I have a document that holds a very large number of entries by date
This file is updated every day with new information, however I am trying to figure out how to save the "last night" figures from one sheet to this sheet that holds all of the historical entries
It is only 2 cells that need to be copied as values only - I have the "Button (Form Control)" done, and a csv file ready for the import of new data for after this step

Thanks in advance to anyone that may be able to point me in the right direction

Cheers
Mike

Without sample data, it's going to be hard, can you share your csv and desired output?

But to get yesterday in VBA, simply use "date - 1"

Hi @JasperD

Thanks for your reply... it would be very difficult to provide the data as the file is very large and there are 5 csv files feeding into it
However, where I need the VBA process to be applied is just between 2 of those worksheets, for example:

Original data in "Sheet 1", C25 & G25
Then the destination range of dates would be "Sheet 2", AV16:AX4632 - column AV is the column with the dates, AW & AX is where C25 & G25 data would need to go respectively

Thanks in advance for any help

Cheers
Mike

Hi @JasperD

Thanks for your reply... it would be very difficult to provide the data as the file is very large and there are 5 csv files feeding into it
However, where I need the VBA process to be applied is just between 2 of those worksheets, for example:

Original data in "Sheet 1", C25 & G25
Then the destination range of dates would be "Sheet 2", AV16:AX4632 - column AV is the column with the dates, AW & AX is where C25 & G25 data would need to go respectively

Thanks in advance for any help

Cheers
Mike

Hi @JasperD

Thanks for your reply... it would be very difficult to provide the data as the file is very large and there are 5 csv files feeding into it
However, where I need the VBA process to be applied is just between 2 of those worksheets, for example:

Original data in "Sheet 1", C25 & G25
Then the destination range of dates would be "Sheet 2", AV16:AX4632 - column AV is the column with the dates, AW & AX is where C25 & G25 data would need to go respectively

Thanks in advance for any help

Cheers
Mike

Hi @JasperD

Thanks for your reply... it would be very difficult to provide the data as the file is very large and there are 5 csv files feeding into it
However, where I need the VBA process to be applied is just between 2 of those worksheets, for example:

Original data in "Sheet 1", C25 & G25
Then the destination range of dates would be "Sheet 2", AV16:AX4632 - column AV is the column with the dates, AW & AX is where C25 & G25 data would need to go respectively

Thanks in advance for any help

Cheers
Mike

This doesn't help.
I have no idea how to identify what your source cells would be?
Always C25 & G25 ?
And then look up yesterday's date in column AV in sheet2?

Can you give some screenshots at least?