Transfer all data from one cell to another, and keep it dynamic

  • Thread starter Thread starter ML
  • Start date Start date
M

ML

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Data From Multiple TAB to One TAB 1
Advanced Excel--Want to click on Cell & Move to Other Tab 3
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Transferring data between worksheets? 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to Combine Data from Multiple Sheets with Cell References 4
conditional format code based on lookup from another tab 1
Transferring data from one hard drive to another 2

Back
Top