Copy Data From Workbook

[Justair07]

Hello,

I'm slowly learning VBA but have not have not been able to accomplish what I'm trying to do with this project. Here is the little amount of code I have so far.

Please Login or Register  to view this content.

I'd like for the macro to paste data for the day before its ran. For example: If I run the macro on the Sunday(6/2/2013), I'd like the data for Saturday(6/1/2013). Or if the macro is ran on Monday(6/3/2013) but there is no data for Sunday(6/2/2013) I'd like it to skip to Saturday(6/1/2013) (or the first date with data).

The dates are in "A" and the rest of the data is in "B", "C", "D" (data.xlsm).

I hope this makes sense, I did my best to explain.

Anyone that can help me out with this I would appreciate it a lot.

Thank you,

[arlu1201]

You will need to explain some more. Where would the date be mentioned so we know its pulling the date for the previous day?

Do you have a sample file that you can upload?

[Justair07]

arlu1201,

Here are two samples. The data workbook contains the dates and data I want to copy from. The piechart workbook is where I would like the data to be pasted (replace current date and data).

Thank you for your reply and I hope this helps,

[arlu1201]

How about this - ?

You specify the date in Pie Chart D2 and the macro pulls up the values for you?

If you specify the date, you do not need a macro. Even a vlookup can pull up the data for you.

[Justair07]

The VLookup is almost perfect! But what if new data is entered, is there a way to refresh the vlookup so if I add a line of data it will automatically pick up in the vlookup?

Thank you again for your help!

[Justair07]

I just realized that Vlookup will update once I reopen the workbook. Thank you for your help on this. Much easier than my approach.