How to add new row each day automatically?

[viktor_david]

Hi,

I have the following problem:
I want a way that tomorrow there is a new Row (thanks for correction,Joe4) automatically in my excel that shows the date and the price.
So today it shows like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: right"]A[/TD]
[TD="align: center"]02.05.2017[/TD]
[TD]320[/TD]
[/TR]
[TR]
[TD="align: right"]B[/TD]
[TD="align: center"]01.05.2017[/TD]
[TD]310[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


And tomorrow I want it to look like this without me having to insert a new row manually:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: right"]A[/TD]
[TD="align: center"]03.05.2017[/TD]
[TD]315[/TD]
[/TR]
[TR]
[TD="align: right"]B[/TD]
[TD="align: center"]02.05.2017[/TD]
[TD]320[/TD]
[/TR]
[TR]
[TD="align: right"]C[/TD]
[TD="align: center"]01.05.2017[/TD]
[TD]310[/TD]
[/TR]
</tbody>[/TABLE]

How can I do this?
Note: I know nothing about VBA.

Is it faster for excel to open when it's filled with macros or when it's filled with formulas?

Thanks guys

 

[viktor_david]

The problem with that comes when days like yesterday happen. market wasnt open on a Monday.. but i can find solution if we can put numbers instead

 

[Joe4]

Is it possible that instead of dates it inputs numbers? so basically A1 today is 0, yesterday's date is 1, before yesterday is 2. And tomorrow, tomorrow's date will be 0, today's date will be 1, yesterday's date 2, and before yesterday's date will be 3.
Is it possible?

The issue with that is when it opens the file tomorrow, how will it tell if that zero is from today or yesterday?
You would need to "capture" or store the date somewhere, so it knows if it already ran for the current date or not.

If you want something like what you are asking, I might recommend adding another column with the formula:

=ROW()-1

That will return 0 for row 1, 1 for row 2, etc.

By the way, I added code to my last post (don't know if you saw that).

 

[Joe4]

The problem with that comes when days like yesterday happen. market wasnt open on a Monday.. but i can find solution if we can put numbers instead

Not sure where you are located, but the markets were open here yesterday!
Is there any way to identify non-weekend dates when the markets are not open?
What does your formula in column B return in those instances?
Maybe we can have it automatically delete those rows, based on whatever it is you see in those instances.

 

[viktor_david]

Yes, it copied/pasted the 2nd code and it runs smooth.. actually the holidays do not show blank, the show the previous price.. .so if the number one doesnt work, ill stay with the second you sent.
Let me try to do it...
Live saver, sir

 

[viktor_david]

Actually I can work with second code, because there is no wway to identify those dates since they do not show blank, but show previous price.. but that is not a problem, I can work with that.. In any case, if that is a problem I will hit you up again with a question.
It is nice to get this help.
Thanks a lot sir, Have a great day...

OH i almost forget...
How excel gets slower? when filled with formulas or when filled with macros?

 

[Joe4]

Unless you have a ton of VBA code, it is is probably faster with the VBA code.

One possible solution to your holiday issue is to create a lookup list of all holiday dates. You could then have your VBA code check to make sure the date it is writing for is not found on that list.

 

[viktor_david]

Hello, Sir

Sorry for not replying your last message. I did not see it.

I am looking to continue further with this project.
Are you available to help me a bit more with this, because that was the first part of the project hehe...
Maybe You have some free minutes?

Thanks

 

[Joe4]

If you have new questions (even if they are on the same project), please post them to a new thread. You would only post it to the same thread if it is a directly-related follow-up question that it is necessary for the people to see the previous responses in order to answer the new question.

That way, others will see that there is a new unanswered question. My time around here has been a bit limited lately.

Note that if you are looking for someone to help you with a project the whole way through, you may want to consider hiring a consultant. MrExcel does offer those services too: MrExcel.com | Excel Resources | Excel Seminars | Excel Products