VBA for a newbie help on consolidating sheets on 1 master sheet

Try this code............

Please Login or Register  to view this content.

The records entered in all the tabs will automatically transferred to the master sheet, once the user input the value in col. I of a row which is additional notes. This way the incomplete records will not be copied to the master sheet.
Find the attached sheet to see if this fits to your requirement.

Please follow these steps.
1) Open your workbook.
2) Press Alt+F11 to open VBA editor.
3) On the left hand side panel which list your workbook along with all your sheets names. Below the sheets names, you will find ThisWorkbook.
Right click on ThisWorkbook --> View Code
4) Then in the opened code window, paste the code given in post#2.
5) Close the VBA editor.

And you are done. Your code is ready to work.

Hope this helps.

@gabz1989

You need to allow excel to use macro's.

you file has the extension .xlsx (see #1)

a macro enable file has the extension .xlsm (see #2)

So you need to save the file as Excel workbook with macro's

That's my mistake. I didn't tell you that after applying the code in the workbook, you had to save your workbook as Excel Macro-Enabled Workbook. Follow these steps.

1) File menu --> Save As --> From Save As drop down list --> Excel Macro-Enabled Workbook --> Save
2) Once the file is saved as Excel Macro-Enabled Workbook, you will notice that the file has the extension .xlsm but not .xlsx

Let me know if you need any further assistance.