finding corresponding row
In Sheet A of data, in Column B, I have a year (say, 2003). For each row
(and year) in Sheet A, I'm trying to get the macro to find the row of the
corresponding (identical) year on Sheet B, then copy the appropriate data
box for that row, and enter it into an equation with a data box from the
initial row in Sheet A. I'm having a difficult time figuring how how to get
the macro to do that recognition process, and then to capture the right
cell. Can anyone please help with this? Thanks.
Best,
Luke
|