static to variable

Please forgive the excel ignorance.. and this is probably a simple thing to most..

I import data each day. Out of the various data files that are imported I need to get certain bits out of the data and put them to the appropriate row of different sheets. I have it figured out how to get to the empty row but I'm not sure how to get the data from the static location to the variable location.

Example:

Data sheet - I need to get values from DATA! A3, B3, A4, B4, A5, B5, A6, B6. The data I need is always at these locations but the values change.

Now I need to copy this data to the correct sheet, row and column but the row changes on the other sheets....

A3, B3 --->> Sheet1 G?, H? (row changes based on date)
A4, B4 --->> Sheet2 G?, H? (row changes based on date)
A5, B5 --->> Sheet3 F?, G? (row changes based on date)

I guess what I'm trying to ask is how do you copy static locations to variable locations? Or rather how do you write the code to reference a static location and put the values in changing locations?

Try post your question under the VBA section.

You can set formulas in your target lists
Examples: =IF(ISBLANK($A$3,"",$A$3) or =$A$3, ...
but I think this is not what you want. You want something like a button =PUT(A3, formula(in last cell in my list)) ... - would be a handy formula.

Try the VBA forum.

Ola