I am using a lookup function to create a few graphs but I need to change part of this function with todays date.
=VLOOKUP($A$1, 'Q:\CVW\InfoShare\Operations\ABS_Stores_Charts\Daily Inv\Archive\[CVWDailyInventory_200710240100.XLS]Sheet1'!$K:$L,2,FALSE)
Above is my lookup function and I want to replace 20071024 with 20071025, and then for tomorrow it should 20071026 and so on.
Any ideas on this ?
This should give you a basic way to start what you want to do.
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks