Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with calc across two worksheets
I'll try to explain as easy as possible -
You have two worksheets, the first is a table of info - football league table per say. The second worksheet has data and calculations done on where a team is in the table. Problem :- As and when the table is sorted the team moves up/down, BUT the calc formula in the second worksheet still points to the original cell. Question :- How do I make the second worksheet formula take into account the fact the the cell 'moves' ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with calc across two worksheets
Suggest the easiest way would be to use VLOOKUP in the formula in the data sheet that looks up the team names in the first sheet and extracts the data that way. HTH Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=565486 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem renaming worksheets | Excel Discussion (Misc queries) | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Problem with Calculating Worksheets | Excel Worksheet Functions | |||
Problem using excel workbook in word mailmerge | Excel Discussion (Misc queries) | |||
Problem with time calc | Excel Worksheet Functions |