cell reference excel

Microsoft Microsoft excel 2007 full vers...
September 7, 2010 at 11:32:14
Specs: Windows XP
I have a workbook (A) containing addresses in Cells A1 through A10 for example

I have another workbook (B) where a new worksheet will be created for each address in the workbook (A).

I want the address to be displayed in cell b4 in worksheet B.

I can get the first address to display in workbook B by using Paste link, but I am lost as how to get each additional worksheet to display the addresses. Ex. worksheet (2) to show the address from workbook(A) row A2, worksheet (3) row A3.....

Thank you for your help


See More: cell reference excel

Report •

#1
September 7, 2010 at 13:10:15
You're confusing us (well, at least me!) by your use of the terms workbook and worksheet.

A workbook is an Excel document that contains 1 or more worksheets.

Therefore, when you say:

I have another workbook (B)

and then say:

I want the address to be displayed in cell b4 in worksheet B.

you confuse us. (me!)

It might be best if you referred to your workbooks as A and B and then used Sheet1, Sheet2, Sheet3, etc. to refer to your sheets.

Workbook(A) Sheet1
Workbook(B) Sheet3
etc.


Report •
Related Solutions


Ask Question