Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
I have fuel meteres at unattended sites where my customers dispense fuel. I
am wanting to gather the meter readings on a spread sheet. I then want to reference to that sheet comparing it to later readings to determine the amount of fuel dispensed. I can make it work by entering formulas in the spreadsheet, but when I try to make the formula accept the file name I generate by entering the date, it doesn't work. =+B6-[10.28.2005.xls]Sheet1!B6.. I've tried building the file name "10.28.2005" but it will not work in the formula. Any help I could get with this would be most apprecaited... Thanks NJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
Hi Nick, Why is there a +b6- after your =? if you file is on your computer say the desktop, Shouldn't your file path be something like this? ='C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$b$6. Hope this helps Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=488374 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
Larry:
What I'm trying to do is build the file name that I need to use for caparisons within the the sheet by entering dates in a cell. If I can do this then my program for accounting for the fuel dispensed at each of my nine fueling stations. Thanks for the response. "keithl816" wrote in message ... Hi Nick, Why is there a +b6- after your =? if you file is on your computer say the desktop, Shouldn't your file path be something like this? ='C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$b$6. Hope this helps Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=488374 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
Larry:
The B6 is my current meter reading. I want to compare it to a meter reading I have entered on a previous date in a spread sheet that is formatted in exactlythe same manner. Byu doing this I can compare a meter reading at any given date with a meter reading from any other date. If I can build the file name... I've read that in order to do this that both sheets have to be open at the time. If I can get this done, it will solve a very perplexing problem in my business. Thanks Nick "keithl816" wrote in message ... Hi Nick, Why is there a +b6- after your =? if you file is on your computer say the desktop, Shouldn't your file path be something like this? ='C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$b$6. Hope this helps Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=488374 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
Hi NJ, You have a reading in B6 of the main spreadsheet and you collect data from another spreadsheet, you transfer the data to the main spreadsheet and want to compare the two pieces of data. would something like this work? =b6-'C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$B$6 Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=488374 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use a cell value to reference a worksheet name | Excel Worksheet Functions | |||
How do I reference pictures in a worksheet? | Excel Discussion (Misc queries) | |||
Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |