Reading Values from another sheet

[Rabi]

Hi geeks

I have two Worksheets: "data1" and "data2".
I need to put values in column "description" of the "data1" sheet from the corresponding row numbers and "event" column of the "data2" sheet.

I unsuccessfully tried different formulae, in each cell of the column "description" for the "data1" sheet; similar to the following Pseudo syntax:

= sheets("data").range(CurrentRow, "event")

Please help.

Rabi

 

[craig.penny]

Try this

= sheets("data").Cells(CurrentRow, Range("event").Column)

 

[Rabi]

Thank you so much for your attention. Unfortunately, it does nto accept the formula, with the following message:

"The formula you entered contains errors"

Further help will be appreciated.

 

[craig.penny]

Oh sorry, I assumed you were posting a partial line of VBA code.

If you're doing this on this worksheet, why not just go to the top target cell and do "=" and then select the source cell? Then copy down?

 

[Rabi]

Well, the requirement of the large Worksheet, with frequent updates, is that it has to be done dynamically. Further to it, I am personally interested to enhance my skill in using worksheet functions.

I hope, you geeks will support.