|
|
|
|
"Skot" ha scritto nel messaggio
Not sure if my subject helpeds explain much.
I have a "register" worksheet, that tabulates all the information
found on the other worksheets in the database. The register worksheet
is called "register" and the other worksheets are numbered "1", "2",
"3" and so on.
At the first row of the register worksheet, i have a lot of cells that
reference off the "1" worksheet. Simple links so i can see all the
information i want on one screen.
On the second row of the register, i want the same cell locations,
but on the second ("2") worksheet, and this continues through. The
first column contains the worksheet number "1", "2" etc.
I've hunted around with different fill techniques, and different
reference techniques but haven't been able to find anything.
Hopefully someone out there has a better idea than i do. Open to ALL
ideas as its is just a new spreadsheet.
If you have absolute references in the link in row 1 you can simply copy and
past down in row2, 3 and so on. then with Find and Replace you can Replace
Sheet1 with Sheet2 in the second row and so on.
--
Hoping to be helpful...
Regards
Franz
----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------
|