Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet.
Hi,
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. I.e. I'm working on a budget. In "sheet 1" I want to view the employees and their billable hours sorted by the teams the employees belong to. I want each employees row/info to be linked to "sheet 2", where it contains all the same info, but the sort is by employee position, not team. In otherwords I only want to enter information into the sheet sorted by position, and have the sheet by team automatically pick it up. I also want the ability to sort position sheet by other ways, but have the sheet 1 maintain the references and format. Hopefully this makes sense. Thanks, Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |