Importing data from 1 Excel Sheet to another [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have a program that exports the daily maximum temperature recorded into an excel spread sheet. Column A Row 1 Date Column B Row 1 Temperature. This gets repeated for each day. Every day the temp for that day is recorded and the sheet grows.

At the end of each month I need to present these figures in a certain format which is in Excel sheet.

Would it be possible to to take the information from the first sheet and import/send it accross according to the date.

I have been using copy paste but there are 89 sensors and this does consume alot of time

Thank you for your help with this matter. I have no experience with Macros but If I have the code then I should worki it out



1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
are you copy pasting row by row

if you want the whole sheet is to be copied to another sheet

select any cell
click control+A all will be slected
edit-copy(or control C)
go to the destination sheet A1 (no other cell)
click edit paste (or control v)

now the destination sheet sort according to date.

is this what you want ????

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!