Hey Guys,
So I have a file which updates everyday and adds number to month to date file.
Now, I want to use that month to date (MTD) file and split it into 4 weeks.
starting from 1st to 7th and so On.
I want the particular column and row to read MTD file only till 7th and then a new column to start reading it from 8th and stop on 15th and so on.
Can this be done?
Thanks.
Not sure about anyone else, but I would need to see some sort of Workbook layout, and any macro's that may be running to create your data, and some idea of what you want posted in a sample workbook to offer any valid solution...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hey...
Sample spreadsheet is attached.
Sorry for taking so long to respond, have had a touch of the flue, so haven't been able to concentrate too well
Look at the attached, I've offered 2 different options there
(Note - You may get a circular reference error when you open, this is because one of the solutions require a circular reference to work(the one on 'Sheet1'), the option on 'Sheet1(new)' does not require the circular reference)
Hope this helps
Thank you soooooo much!
Both the solutions work perfectly
You are very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks