Previous Topic Next Topic

Importing data from 1 Excel Sheet to another

Closed
Saffa999 - Aug 22, 2011 at 05:18 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 23, 2011 at 01:17 AM
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



Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 23, 2011 at 01:17 AM
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 ????