Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 08, 11:50 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 36
Default pulling data from two spreadsheets

Good Morning,

I need to produce a spreadsheet on a weekly basis that is derived from two
spreadsheets.

Currently I link two spreadsheets into Access and then run a query to
produce a single spreadsheet containing the combined data. The problem is
this is not real quick and requires tweaking the formats of the two
spreadsheets.

I am trying to see if I can do this in excel via a macro and/or formulas.

Is this possible or should I stick with access?

Thanks

Fred

  #2   Report Post  
Old January 16th 08, 04:40 PM posted to microsoft.public.excel.setup
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,998
Default pulling data from two spreadsheets

You should be able to do the whole thing in Excel. Try turning on the Macro
Recorder, and doing the operations by hand, and then turning off the
recorder...........you now have a macro to do the job (hopefully, cause some
things will not record). But at least, you will have something to edit, or
to show us what you want to do and we will help tweak it for you.

Vaya con Dios,
Chuck, CABGx3


"fgwiii" wrote:

Good Morning,

I need to produce a spreadsheet on a weekly basis that is derived from two
spreadsheets.

Currently I link two spreadsheets into Access and then run a query to
produce a single spreadsheet containing the combined data. The problem is
this is not real quick and requires tweaking the formats of the two
spreadsheets.

I am trying to see if I can do this in excel via a macro and/or formulas.

Is this possible or should I stick with access?

Thanks

Fred



Reply
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
Tying to extract all data from a pivot pulling from external data Ted Urban Excel Discussion (Misc queries) 3 September 14th 07 10:50 AM
Linking two spreadsheet, pulling data from one cell to another, data is being truncated Ben Excel Worksheet Functions 0 September 13th 07 11:41 PM
Pulling data yaheegunsome Excel Worksheet Functions 1 May 17th 07 10:23 PM
Pulling info from other spreadsheets based on a set of criteria... watchtower Excel Worksheet Functions 1 February 3rd 07 02:32 AM
pulling data from one sheet and listing selected data in another Bfly Excel Worksheet Functions 2 February 2nd 07 01:38 AM


All times are GMT +1. The time now is 10:28 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017