| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy data from one worksheet to another
Worksheet 1 has data that will always stay in there appropriate cell address
and be available for only one person to update. Worksheet 2 will be a copy of Worksheet 1 but only used to sort by criteria in a given column and only be used for sorting purposes by more than one person. Any data that is changed in Worksheet 1 will automatically change the data in Worksheet 2. How can I accomplish this? The "=Sheet1!$A$1" function is not feasible since I am over 150 columns wide and at least 1000 rows deep. I am sure there is some other way to accomplish this task! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data from one worksheet to another | New Users to Excel | |||
| copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
| copy data from a worksheet | Excel Worksheet Functions | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
Threaded Mode
