Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer all data from one cell to another, and keep it dynamic
I need to transfer (via link?) info from one cell in one tab to another cell
in another tab - the tabs are in the same file. I need to transfer everything - including background colour, and if it changes, it changes both places. Is it possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer all data from one cell to another, and keep it dynamic
ML,
It is possible, with event code. How many cells do you want to have behave that way, and which of the cells is the 'master' - the one to copy if the formatting, etc. changes? HTH, Bernie MS Excel MVP "ML" wrote in message ... I need to transfer (via link?) info from one cell in one tab to another cell in another tab - the tabs are in the same file. I need to transfer everything - including background colour, and if it changes, it changes both places. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer data from a cell to another workbook if certain criteria | Excel Worksheet Functions | |||
transfer data cell from another work sheet | Excel Worksheet Functions | |||
How do i transfer cell data from one sheet to the other in Excel | New Users to Excel | |||
Transfer cell data from one worksheet to another === URGENT | Excel Discussion (Misc queries) | |||
Can data from one ws transfer to another IF cell has text? | Excel Worksheet Functions |