Loop Macro
Hello,
I want to do something, but not quite sure how.
Capture.PNG
I have a table in which I add "x" in all of the green Cells( B2:P17) and I have a Specific start date in cell B1, and every 56 days like an automatic cycle I want the values in range B2:P17 to be deleted.
Please give advice.
Thank you in Advance!
Last edited by Afir1k; 08-03-2017 at 07:59 AM.
Hello
It is better to upload sample of your file ...
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
One moment
Delivery Time.xlsx
here it is
Can you give more details or put some of your desired output?
How would you like to put x and on what basis?
i have 13 Products and the green Cells represent the quantity available on stock.
and when an X is entered it means it was requested , and these Products come automatically in a Cycle of 56 days and that way we track what we have on stock and what we sold
So when 56 days pass i want these cells to be cleared automatically because we have the quantities again , like a refill if all are not bought
It is still not clear for me. May be someone else can help you out but it will be better if you put the expected output
Capture.PNG
so it looks like this and after every 56 days i want it to look like this
Capturse.PNG
so I add "x" from time to time and when 56 days pass I want the Cells to go back to green
Last edited by Afir1k; 08-03-2017 at 08:48 AM.
is this more clear ?
or is it even possible?
Thanks for your time I appreciate it.
Try this code. May be a start for you
Please Login or Register to view this content.
oh ... yes i did not specify what i wanted....sorry
So I only want the "X"s to disappear every 56 not everything else. Nothing wrong whit the colors.
This will clear the Xs 56 days after the date in cell B1.
The macro automatically runs when you open the file.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Is there a way to make it like a Cycle every 56 days.
Like i have today's date 3.8.2017 after 56 it clears and when 28.9.2017 comes and the data delete an after another 56 it deletes again and so on ?
I think AlphaFrog's code do what you are telling about in post #14 ..
This will do the same thing but also add 56 days to the date in B1 and then delete again on the next date. Is that what you want?Originally Posted by Afir1k
Please Login or Register to view this content.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks