• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data to appear automatically on specified row

SouthKaDaaku

New Member
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.
 

Attachments

SouthKaDaaku

New Member
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.
 

vletm

Excel Ninja
SouthKaDaaku
Sorry to say - but for me it works as You understood.
After You've opened that file, it should show as below.
Screenshot 2022-01-07 at 09.32.43.png
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

New Member
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

New Member
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:)
 

vletm

Excel Ninja
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

New Member
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:)
 
Top