(Msg. 1) Posted: Tue Sep 02, 2008 5:50 pm
Post subject: Combine daily data from different worksheets Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Using excel 2003. How can I combine different bits of info to 1 sheet, eg...
one sheet contains temperature and humidity for every day of the year, next
worksheet contains water used only on week days. I would like to match each
entry to the correct row(day) on one sheet. I do not care if I lose the
weekend data from the first sheet.
(Msg. 2) Posted: Tue Sep 02, 2008 8:50 pm
Post subject: Re: Combine daily data from different worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
(Msg. 3) Posted: Tue Sep 02, 2008 9:49 pm
Post subject: Re: Combine daily data from different worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Rhino721 wrote:
> Using excel 2003. How can I combine different bits of info to 1 sheet, eg...
> one sheet contains temperature and humidity for every day of the year, next
> worksheet contains water used only on week days. I would like to match each
> entry to the correct row(day) on one sheet. I do not care if I lose the
> weekend data from the first sheet.
(Msg. 4) Posted: Thu Sep 04, 2008 7:39 pm
Post subject: Re: Combine daily data from different worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
That Got me closer. And the "how to" snapshots were great as I would not have
gotten close with out them. I can see Pivot's will require practice and
trial and error. Thank you.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office