Date Lookup to initiate data populating another worksheet

**Crhodes** · 05-18-2013, 09:33 AM

What formula can I use:

I'm trying to use a date to trigger data populating from one sheet to another. I attached a spreadsheet that has the data on one tab and the second tab that needs the data to populate.

Thanks!

**JBeaucaire** · 05-18-2013, 09:47 AM

Please clarify the process you intend to operate here.

1) Data is manually inserted into "Data Want Transferred" sheet.
2) At some given trigger, the data is PHYSICALLY transferred to "Data Transfer Sheet" permanently.

3) steps 1 and 2 above can be repeated for a new date?

I ask because a formula cannot do this. To make physical and permanent entries into the second sheet would require VBA and some method of triggering it.

Questions:
a) Is this what you had in mind?
b) Is VBA alright to employ?
c) If the SAME date is used on sheet1 more than once, what happens? Does the data transfer to sheet2 on a new row, or does it need to find the original row and replace the data sent over earlier?
d) Does sheet1 need to pull BACK from sheet2 the existing data if it exists and the existing date is put into A2?

**Crhodes** · 05-18-2013, 01:31 PM

Jerry - your assumptions for 1,2 & 3 are exactly correct. A VBA is alright to use as well.

The data in sheet1 needs to transfer to sheet2 one time in a blank row with the corresponding date. Then I'm thinking I can just copy & paste special value it so I can repeat this step the next day for the next date. So sheet1 does not need to pull back to sheet2.

**JBeaucaire** · 05-18-2013, 04:32 PM

I can't help but ask... then why not simply enter your data into sheet2? It's a small form and TABBING across a single row entering values is far simpler than mouse-clicking through the "layout" on Sheet1. Sheet1 looks nice, but from an end-user standpoint doesn't offer a simpler input that sheet2 already does.