I have a workbook, basically of individual account details, but I also need a summary sheet with some information from the account details page. A bit difficult to explain but I shall try:
The individual account details sheets would have name, address (in 4 separate fields) and a total box being the sum of sales on that sheet. These sheets would be added to as new accounts were set up.
The summary sheet would have have columns for names, addresses and total boxes.
The initial link would be in the format of =Example!E1 for the name, followed by =Example!F1; =Example!G1; =Example!H1; =Example!J1; etc for the details on each account.
My question is: having entered the first link (E1) what formula could I use for the subsequent F1, G1, H1, J1 linked cells without having to link each cell from the new? For subsequent accounts I would then enter =Example2!E1 then copy across the relating cells from the row above.
I hope this is clear!
Bookmarks