Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another linking question
I have a Worksheet called “DailyReport” with a number entered in cell A1, such as 23rd, 24th,25th,etc I’d like to have it auto enter a number in Cell A2 that comes From a file called “ProdReports”, and from sheet “23rd” cell A10, or “24th” cell A10,etc,depending on what sheet number is typed into cell A1, of the worksheet ”DailyReport” Thanks, Greg -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=479533 |
#2
|
|||
|
|||
Another linking question
Sounds like a job for Indirect, Greg. See this:
http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "singlgl1" wrote in message ... I have a Worksheet called "DailyReport" with a number entered in cell A1, such as 23rd, 24th,25th,etc I'd like to have it auto enter a number in Cell A2 that comes From a file called "ProdReports", and from sheet "23rd" cell A10, or "24th" cell A10,etc,depending on what sheet number is typed into cell A1, of the worksheet "DailyReport" Thanks, Greg -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=479533 |
#3
|
|||
|
|||
Another linking question
Thanks Anne for the suggestion .Unfortunately, the workbook that I'll be referencing will not always be open , therefore I'm not sure if the indirect function would work for me. -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=479533 |
#4
|
|||
|
|||
Another linking question
That'd be correct. Sorry. :(
Have you seen this post at Dick's? http://www.dicks-blog.com/archives/2...sed-workbooks/ ************ Anne Troy www.OfficeArticles.com "singlgl1" wrote in message ... Thanks Anne for the suggestion .Unfortunately, the workbook that I'll be referencing will not always be open , therefore I'm not sure if the indirect function would work for me. -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=479533 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Question about auto fills or linking sheets | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |