Data to appear automatically on specified row

[SouthKaDaaku]

Hi All,

I have a data set that gets regularly updated. The latest data should be on top always for better analysis.

For example, if I have data for Day 1 and want to enter data for Day 2, I should not have to insert a row always above Day 1 Data. A new row should be automatically created.

Sharing a sample file for better understanding.

Thanks in advance.

 

[vletm]

SouthKaDaaku
Something like this?

 

[SouthKaDaaku]

Hey vletm,

Sorry to say, this is not the required solution.

When I'm running the macro in this sheet, a new row is being added below each of the existing data points.

The behaviour i'm looking for is that after entering the various data points in the row, a new blank row should appear above it.

Thank you for your time.

 

[Belleke]

Like this?
Insert your data in the green cells and push insert data button
Row 3 stays blank and is hidden,data is inserted in row 4

 

[vletm]

SouthKaDaaku
Sorry to say - but for me it works as You understood.
After You've opened that file, it should show as below.

What are You writing about When I'm running the macro in this sheet ?
You do not need to run any macro - as You wrote automatically.
Your original is:
For example, if I have data for Day 1 and want to enter data for Day 2, I should not have to insert a row always above Day 1 Data. A new row should be automatically created.
= One new line per day to row two ... with bonus automatic date.

 

[SouthKaDaaku]

SouthKaDaaku
Sorry to say - but for me it works as You understood.
After You've opened that file, it should show as below.
View attachment 77447
What are You writing about When I'm running the macro in this sheet ?
You do not need to run any macro - as You wrote automatically.
Your original is:
For example, if I have data for Day 1 and want to enter data for Day 2, I should not have to insert a row always above Day 1 Data. A new row should be automatically created.
= One new line per day to row two ... with bonus automatic date.

Yes, it was coming like this. So I can fill today's data.

However, after saving it and reopening it a new row on top of today's data was not getting created.

That's what I was telling about.

If I hadn't spelled out my problem clearly, I'm sorry

 

[SouthKaDaaku]

Like this?
Insert your data in the green cells and push insert data button
Row 3 stays blank and is hidden,data is inserted in row 4

Hey Belleke, this worked for me!! Thank you.

However, could you explain why you hid the Row 3 data and let the data enter Row 4?
Also, is there no formula that can do this ?

Thank you so much once again

 

[Belleke]

If you use row 3 then then row 3 will have the same format as row 2 (green with borders)

 

[vletm]

SouthKaDaaku
About Your
For example, if I have data for Day 1 and want to enter data for Day 2, I should not have to insert a row always above Day 1 Data. A new row should be automatically created.
For me, above means that there could be one data per today ( today ) as You've written.
With my sample, You could use row two for today's data as You also has written.
It would also possible to use filtering this way.
Ps. Same features could get, if You would use table ... and sort Your date if really need. As well as frozen header row would be useful.

 

[SouthKaDaaku]

SouthKaDaaku
About Your
For example, if I have data for Day 1 and want to enter data for Day 2, I should not have to insert a row always above Day 1 Data. A new row should be automatically created.
For me, above means that there could be one data per today ( today ) as You've written.
With my sample, You could use row two for today's data as You also has written.
It would also possible to use filtering this way.
Ps. Same features could get, if You would use table ... and sort Your date if really need. As well as frozen header row would be useful.

Ok....Thank you

 

[SouthKaDaaku]

If you use row 3 then then row 3 will have the same format as row 2 (green with borders)

Ok Thank you!