Move and shift data depending on time period

Hi, welcome to the forum.
Yes it can. but what do you want to do with the obsolete data?
You can choose to juts hide these rows but also to delete them.
You could also add a new worksheet and there just display those rows you want to say with formulas so that the original data stays intact.
Like a view sheet
I suggest a sample workbook with some dummy data would help give your explanation a picture.

Thanks for your reply.

Ideally, when last weeks data becomes 2 weeks old, it then transfers to Sheet3 (Archive).
Archive keeps data for a month, after this period the data starts to be deleted.

Otherwise, I just wish for the rest of the data (parameters above) to be shifted depending upon the date.
So if the spreadsheet was opened this morning, the data at the top would be week commencing 13/02/17 (last week)
Data with 06/02/17 would have been moved to the archive tab (as it is now 2 weeks old). 20/02/17 data would have been shifted up from next week to current week, etc etc.

More than happy to attach the workbook or even just a screengrab pic to help explain - how can I do this?

Thanks!

A screen grab, no, you can attach a file, select Go Advanced when replying and then look for Manage attachments, then select the file and press Upload file then close window and submit reply, if you more tha one file you can slecet another onet and upload and again and then close window and submit reply.

I can't promise you I have the solution but I'd like to take a look. Are you familiar with macros (specifically VBA code)? This because you will have to some maintenance yourself and should not become dependent of others.

Unfortunately I seem to only get a white line when trying to upload an attachment - could be blocked by policy at workplace.
I can upload the file when I am at home later today for you.

Familiar at beginner level, yes. I have already added some vba functionality to the workbook.
I will upload in around 6 hours time, unless there is another place to upload between now and then - thanks

Doesn't appear that I can upload any attachments, nor on my work pc or personal pc, so I will have to do my best at explaining to you roughly how my workbook is set up.

Essentially:
- Sheet 1 has buttons to filter the data in sheet 2 (time period views I have mentioned above).
- Sheet 2 contains the Data, as an example, in cells A2:X26...
So A2:X6 is last week, A7:X11 is the current week, A12:X16 is next week, A17:X26 is the next 2&3 week view.
- Sheet 3 is an Archive tab containing data from the week before last.

Hope this helps paint the picture of our earlier conversations and what I am hoping to achieve.

Many thanks.

It's strange that you cannot attach files. I've attach a quick-and-dirty instruction maybe it helps.

Thanks! I didn't even notice that link. I was using the attachments button above the text window and for some reason it is not working.
Your method worked great, hopefully you can see the attachment now?

Thanks!

Attachment seen and downloaded, I will check and see what I can do to help you

If they contain data you do not wish to share you must delte the attachment from the post. If you cannot then ask a moderator.
I shall repost it with my solution without the hidden sheets.

Question: Do you have a problem if two (hidden columns) are added before Column A.
A will become C and X will become Z

Extra columns will not be needed.
For straters code for the Raw Data sheet's VBA

Please Login or Register  to view this content.

Test and see, the macro is triggered when that sheet is activated.

Firstly, many thanks for your time on this.
Ok, so to test I changed the dates of the first few row's of data in Raw Data to the week before last. Clicked back on the tab and they were gone as expected and everything else shifted up - great

However, they didn't seem to get moved to the Archive tab, but appear to have been hidden instead? The Archive tab still houses some test data I already had in there, but this wasn't added to like expected?

I wish for the data to be shifted up so if we were to open this workbook next Monday, this current week (as of today) will become last week so will be at the top of "Raw Data"... the current Last Week stuff which is at the top of "Raw Data" right now, will move to Archive. Hope this makes sense?

Many thanks.

It does, the data for today's Last week is first hidden and all data that was previous week's last week isx then unhidden and moved to archive.
That is how I wrote this.

The first loop checks for older data (Hidden rows which are prvious weeks Last week and unhides them and copies them to Arcive, then the second Look removes these rows from Raw Data and the third loop hides Last week's data

Here is my file and a PDF showing before and after
All you have to do is modify the VBA code to say <= wkNow instead of < wkOld if you want to mode 06-02- to archive too

Remove the third loop.

True, good work see, it's not that difficult.
VBA is just plain step by step instructions carried out one after another and if you read it like you a series of instructions you actually see what happens, that's all there is to it

JRC1 - I have tidied up the unnecessary quoting - please stop doing it unless crucial to your post. It rarely is, in fact.