Automatically auto-fill cells, when inserting new row

You can do it via VBA or Tables.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you for your response!

I have now uploaded a before and after workbook. In the after workbook under "Data", I have added a new row (19). I have then inputtet my desired data. The sheets "May", "June" and "July" get their data from the "Data" sheet. The problem is that upon adding the new row, the functions doesnt apply for the new row and I have to manually click and drag the data for all of the different sheets for the new row. I have to do this for the data in the columns A-C, but also from AM-AX(which gets it data from the sheets itself). The after workbook is how it should look upon adding the new row and inputting my desired data in in the "Data" tab. I would like the other sheets to adapt to this data. Is this possible?

Thank you so much in advance.

I am sure that someone has a more specific/better idea, but what I would do now it would be to set the data in the adjacent sheets, all except the main sheet as tables including some blanks(like A1:AX100 as the table range) and modify my formulas adding an if

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Etc.

Thank you for your response!

However, if I use that method, the new row in the adjacent sheets is still blank. Any suggestions?

Thanks

New row in yellow, found marked in yellow in June sheet as well.

I've changed the formulas only for June sheet.

Thanks again for your reponse. I guess it works if you only insert new rows in the end of the sheet, but often I'll have to insert new rows in between, like in my example, and then the code wont follow. But thanks anyways!

Anyone got an idea?

This newly added row between your data should appear on all tabs or only on the one matching the date?

As a new row is added to the "data" tab, it should appear in the same row number on all "month" tabs and the code should preferably appear by itself. In my real sheet, i have about 20 "month" tabs, that's why I'd rather not click and drag all the code, for all the tabs.

Assuming all your sheets are contiguous, then click on the first sheet,hold down SHIFT and click on the last sheet. (If they are not contiguous you will have to hold down CTRL instead of SHIFT and click on each one). Then you can highlight the row in the visible sheet and Insert | Row - this will be inserted at that position in every sheet which is part of the group.
To ungroup the sheets right-click on one of the sheet tabs.
Hope this helps.

I already do that, but the problem is not inserting the rows, the problem is that the code doesn't apply automatically to the new rows. The rows just turn up blank. Any suggestions?

Thanks

Hi PaulM100

Actually the code you first wrote, even though simple, did the trick for me. Just with a bit of tweaking!
Thank you for your help! Repped