Cell Reference in a formula

[KJP0422]

I have a file that gives me a list of all cells that have been changed. In the file it references Cell Address as a column of volumes. I need to go to that cell in the original file and copy another columns information.

I have tried several different things and I just cant crack this. Could someone help me please.

Thanks

 

[BrianJN1]

Is this a VBA created reference or one written directly into a cell?
In either case the VBA code or an appropriate sample of what is your issue would be needed.

 

[KJP0422]

Spreadsheet contains following:

Column A = Supplier Name ABC
Column B = Cell Address G11
Column C = Old Value Soup
Column D = New Value Nuts
Column E THIS IS WHERE I NEED TO PUT FORMULA

I need to insert a formula that will go to the sheet( Sent!) cell address E and the row number as specified in the cell address in column B and return that value to this sheet. Hope this helps clarify what I am asking


= Sent!E11

 

[KJP0422]

Can anybody set me in the right direction. I have been working on this formula for 2 days now with no luck?

 

[BrianJN1]

Spreadsheet contains following:

Column A = Supplier Name ABC
Column B = Cell Address G11
Column C = Old Value Soup
Column D = New Value Nuts
Column E THIS IS WHERE I NEED TO PUT FORMULA

I need to insert a formula that will go to the sheet( Sent!) cell address E and the row number as specified in the cell address in column B and return that value to this sheet. Hope this helps clarify what I am asking


= Sent!E11

Do I understand you to be saying that calculations of values of the columns A, B, C & D are to appear in Column E which then are to appear on Sheet(Sent)?