Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 8
Default Updating Links Each Month

I have 3 spreadsheets which I maintain to track sales. One for each of our
branches and one which serves as a master. I've been manually typing the
numbers in each sheet but I am sure there is a way that I can enter the
numbers once in the master and reference the appropriate cells.

The master sheet is quite simple with the entire year on the sheet for each
rep. The branch reports consist of a new worksheet each month. I linked the
branch report to the master report for July. But when I copied the July
worksheet to create the August worksheet, the references to the July column
on the master sheet were copied. How do I enter the references such that
they automatically reference the next column of cells on the master?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200608/1

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 459
Default Updating Links Each Month

dhoward via OfficeKB.com wrote:
I have 3 spreadsheets which I maintain to track sales. One for each
of our branches and one which serves as a master. I've been manually
typing the numbers in each sheet but I am sure there is a way that I
can enter the numbers once in the master and reference the
appropriate cells.

The master sheet is quite simple with the entire year on the sheet
for each rep. The branch reports consist of a new worksheet each
month. I linked the branch report to the master report for July.
But when I copied the July worksheet to create the August worksheet,
the references to the July column on the master sheet were copied.
How do I enter the references such that they automatically reference
the next column of cells on the master?



It's quite difficult to say, because you don't give us any detail...

It would be better if you could upload a sample file to www.rapidshare.de...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 8
Default Updating Links Each Month

Thanks, I have uploaded 2 examples, example master and example. Right now on
example I have the cells linked to the August cells on the example master.
When I copied the August spreadsheet on the example to create a worksheet for
September, the cell references to the August cells on the master are copied.
Is there a way to have the references automatically reference the next
month's cells on the master?

Franz Verga wrote:
I have 3 spreadsheets which I maintain to track sales. One for each
of our branches and one which serves as a master. I've been manually

[quoted text clipped - 9 lines]
How do I enter the references such that they automatically reference
the next column of cells on the master?


It's quite difficult to say, because you don't give us any detail...

It would be better if you could upload a sample file to www.rapidshare.de...


--
Message posted via http://www.officekb.com

  #4   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 459
Default Updating Links Each Month

dhoward via OfficeKB.com wrote:
Thanks, I have uploaded 2 examples, example master and example.


If you don't give us the links to download your examples, it's very
difficult, quite impossible, to download your files... :-)


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #5   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 8
Default Updating Links Each Month

You're right! Have never used RapidShare. Can't figure out how to tell what
the link is.

Franz Verga wrote:
Thanks, I have uploaded 2 examples, example master and example.


If you don't give us the links to download your examples, it's very
difficult, quite impossible, to download your files... :-)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200609/1



  #6   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 8
Default Updating Links Each Month

You're right! Have never used RapidShare. Can't figure out how to tell what
the link is.

Franz Verga wrote:
Thanks, I have uploaded 2 examples, example master and example.


If you don't give us the links to download your examples, it's very
difficult, quite impossible, to download your files... :-)


--
Message posted via http://www.officekb.com

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
Links not Updating Brian Links and Linking in Excel 2 June 1st 06 03:09 PM
Excel 2003 links are not updating between workbooks Tami C Excel Worksheet Functions 3 October 11th 05 02:03 AM
External Links not updating Lou Di Pietro Excel Discussion (Misc queries) 0 September 15th 05 09:48 AM
?? Links Not Updating ?? djm023 Excel Discussion (Misc queries) 3 September 7th 05 02:10 PM
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM


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

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

About Us

"It's about Microsoft Excel"