LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Multiple data query using time reference

Hello everyone,

I am wondering how to accomplish this task. I have multiple data from
various sources. These data have different fields, but the only thing
they have in common is the time. Is there a way for me to somehow add a
data query into a blank worksheet and use the timestamp on each of
these data to populate the blank worksheet?

I wanted to compare the timestamp on each of these data and put all of
the various field with a similar timestamp into one row on the blank
worksheet. I've been messing around with VLOOKUP, but it seems like the
only solution I can think of is programming a macro.

Any tips for a newbie?

My data files have this format:

time | data1 | data2 | data3|
time | grad1 | grad 2| grad3|

I want my blank worksheet to look like:

time | data1 | grad2 | data2| grad2 | data3 | grad3|

Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference web query data in seperate worksheet AmyLRuck Excel Worksheet Functions 1 October 4th 08 04:46 PM
Adding multiple data fields from time based data. JMK Excel Discussion (Misc queries) 1 July 27th 07 10:59 PM
how to query for the appearance of a data entry on multiple works. wriggg Excel Discussion (Misc queries) 0 July 31st 06 09:04 PM
Not as stupid a question; this time about data from multiple sheet Ben Karlin Excel Worksheet Functions 1 May 27th 06 12:45 AM
how do i import multiple data sets at one time? chris_rip Excel Discussion (Misc queries) 3 June 22nd 05 04:27 AM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"