LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Summary File

I am working on making a summary file that takes selected values from other
files and putting them in another file for a quick comparison. Currently I
have it setup where each cell is individually linked to the file and cell
location where it will take the values from. I am trying to figure out how I
can make it do it in a batch, where I tell it what file to look at and it
will take the specified values and put it in the summary file. Instead of me
manually putting in the link each time in the summary file (120 values each
time). The values are in the same locations in each of the files I am taking
it from so it shouldnt be this time consuming.

Any suggestions appreciated,
Thank you.
 
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
how do I email amacro? leo Excel Worksheet Functions 24 August 9th 06 02:47 PM
File A and File B Together BillCPA Excel Discussion (Misc queries) 1 June 6th 06 03:18 PM
disc full, saved to temp. file charlies Excel Discussion (Misc queries) 7 May 18th 06 08:40 PM
file will not open txskyhawk Excel Discussion (Misc queries) 4 April 19th 06 12:35 AM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM


All times are GMT +1. The time now is 12:15 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"