I was hoping to find a way to do this without VBA or macros. I have a start and end date in cells A1 and A2 and I want a table built with the appropriate number of rows based on those dates.
The smallest date range there would ever be is one week so I don't mind building a table with 7 rows. But if i change the date range to say 14 days, I'd want the table to add 7 rows automatically.
Is this even possible?
Thank you.
With no VBA, then you would have to have formulas in all the cells that might ever be a part of the resulting table. IF that's OK, then post a workbook showing the layout of the "resulting table" formed by your start/end dates so we can see it all clearly.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks