How to copy data from one sheet to another sheet

[sony123]

Hi All,

1) I have data in one sheet..i need to put my entire data to another sheet ...is there anyway for me...

2) if possible,can you please answer me like,if i have data in sheet1 and those sheet1 data is inserting into database..if any records missing,i need to put those records into a separate sheet...

Thanks

 

[SirJB7]

HI sony123!
Question widely posed at these forums. Use the built-in search feature at top right.
Regards!

 

[sony123]

suppose i have a an excel file...
That excel contains data as below...it is uploaded by Excel VBA...

Customer no Customer name Address Location
1123 Robert New york US
1124 Alex Washington US
1125 John Clinton US
1126 Jade Marion US

The above file is inserting data into my Database....

if any record is missing like 1124,i need that record into a new sheet....

so in my new sheet i need the below record....


Customer no Customer name Address Location
1124 Alex Washington US


is there any way for me..

Thanks..