Hello,
I was wondering if there was a way to develop some kind of VBA Programming/Macro/Whatever that will open up a spreadsheet, go to A300 (Date Cell), see how many days (from today) that date is back, and post that number into a cell on a different workbook?
Thanks!
I may be misunderstanding your question, but is it sufficient to use this formula in the other workbook?
=TODAY()-'[FirstWorkbookName]Sheet1'!$A$300
Have a great day!
You can do that with a formula.
=TODAY()-'C:\2013\Excel Files\[MyImportantWorkbook.xlsx]Sheet1'!$A$300
Format that cell as General.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ingenious. Now reality presents a problem: I over simplified the problem, instead of A300, how do I point to the 300th cell of a filter? So the 300th cell is actually A7230 today, A2000 tomorrow and so on and so forth.
Don't know of any way to do that. You would need to use a more specific lookup formula to target that row specifically.
Anyway to point Excel to the 300th value in Column with Filter X applied?
Not sure if this will of any use, but maybe you can build on it?
Use the SUBTOTAL(2,range) function
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe?
Sheet3 would be the other worksheet.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks