Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicating/Mirror Data into another worksheet within same workboo
Hi,
I am trying Duplicate Data into another worksheet within same workbook? Example: worksheet 1 and worksheet 2 (both within the same excel file) Q// When I enter data from worksheet 1, I want it to auto mirror exactly into worksheet 2. I do not know how to do this or if it can be done? Please help and thank you in advance. Thanks TJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicating/Mirror Data into another worksheet within sameworkboo
In Sheet2 put this formula in A1:
=IF(Sheet1!A1="","",Sheet1!A1) Copy this across and down for as many cells as you need. Now if you put anything into Sheet1 it will be reflected exactly in Sheet2. Hope this helps. Pete On May 6, 7:52*am, TJ wrote: Hi, I am trying Duplicate Data into another worksheet within same workbook? Example: worksheet 1 and worksheet 2 (both within the same excel file) Q// When I enter data from worksheet 1, I want it to auto mirror exactly into worksheet 2. I do not know how to do this or if it can be done? Please help and thank you in advance. Thanks TJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mirror Columns accross worksheet | Excel Discussion (Misc queries) | |||
Moving last info in column of worksheet to another in same workboo | New Users to Excel | |||
Duplicating a worksheet minus the data | Excel Discussion (Misc queries) | |||
Excel Chart-data references link another worksheet in same workboo | Excel Discussion (Misc queries) | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) |