how to sheet1 data goes to sheet2 automaticaly ?

A

ABDUSSALAM

Hai all
I would like to know one excel sheet1 data to sheet2 automaticaly,which
command use for it ,please....
 
F

Fred Smith

It's a formula. If you're on sheet2, to reference sheet1, use something
like:
=sheet1!a1

Regards,
Fred
 
P

Pete_UK

If it's a one-off requirement you can just use copy/paste, but if you
want it to be dynamic then you can put this formula in A1 of sheet2:

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

then just copy the formula across and down as required.

Hope this helps.

Pete
 

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 Moving data to sheet2 from sheet1 0
How Do I Avoid #REF! In Formulas? 4
Removing items on Sheet1 that are common to Sheet2 1
EXCEL - IF(IFERROR(VLOOKUP question 0
How to have Sheet1 list Sheet2 rows matching text? 7
Excel VBA to move cells to sheet2 based on selection in sheet1 0
How to Populate Data from a table to another 0
specific data 1

Top