Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 4th 10, 04:54 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2010
Posts: 2
Default Need Help with Rows with linked Forumlas

I have a Summary File, and in this summary file each row is linked to
unique external files to grab data. For example:

Summary File:
Row 1 (column A) - Points to ='http://sharepoint/finance/
[file2009_04.xls]Sheet1'!$A$1
Row 2 (column A) - Points to ='http://sharepoint/finance/
[file2009_05.xls]Sheet1'!$A$1

I have over 600 rows with 30 columns and doing a copy/paste/replace is
going to take my years...lol...I was wondering if there was a formula
I could write that would change the file2009_04.xls to file2009_05.xls
to file2009_06.xls as I copy the row down to the next line...any
guidance is appreciated...

I also cannot do a paste value in the end because those linked files
have a tendency to change and then my summary file would be useless

Thanks.

  #2   Report Post  
Old March 4th 10, 05:22 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2010
Posts: 2
Default Need Help with Rows with linked Forumlas

On Mar 4, 10:54*am, nymyth wrote:
I have a Summary File, and in this summary file each row is linked to
unique external files to grab data. For example:

Summary File:
Row 1 (column A) - Points to ='http://sharepoint/finance/
[file2009_04.xls]Sheet1'!$A$1
Row 2 (column A) - Points to ='http://sharepoint/finance/
[file2009_05.xls]Sheet1'!$A$1

I have over 600 rows with 30 columns and doing a copy/paste/replace is
going to take my years...lol...I was wondering if there was a formula
I could write that would change the file2009_04.xls to file2009_05.xls
to file2009_06.xls as I copy the row down to the next line...any
guidance is appreciated...

I also cannot do a paste value in the end because those linked files
have a tendency to change and then my summary file would be useless

Thanks.


nevermind, i got it


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
Forumlas for Dates Nancy S[_2_] Charts and Charting in Excel 1 January 15th 10 02:29 PM
Forumlas Lisa Excel Discussion (Misc queries) 2 August 20th 07 12:12 PM
Forumlas Not Executing Trey Excel Discussion (Misc queries) 2 January 25th 06 05:02 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Help with Commission forumlas asdfasdf Excel Worksheet Functions 6 November 15th 04 06:28 PM


All times are GMT +1. The time now is 09:04 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017