Can data be copied from one worksheet to another?

  • Thread starter Thread starter TinaF
  • Start date Start date
T

TinaF

If I enter data on one worksheet, can that data automatically be copied into
another worksheet?
 
Put this into A1 of Sheet2:

=IF(Sheet1!A1="","",Sheet1!A1)

then copy it across and down over the area of cells that you want this
to apply to. Then when you enter data into a cell in Sheet1, it will
automatically appear in the same cell in Sheet2.

Hope this helps.

Pete
 
Disregard the first reply...Sorry Pete.

All you have to do is select each sheet tab by either using control or
shift. Every sheet that is highlighted will be inputed with the value you
enter.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Excel Move or Copy Stopped Working? 0
Copy from worksheet to worksheet 3
How do I combine data from multiple worksheets into one master lis 3
Copy data from one worksheet to another 4
need help on either doing a loop and counting specific values orusing subtotal function 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top