Help with worksheet with macro VBA adding rows

[O'Shea]

Hi folks, this should be a simple one for all you clever chaps out there.

I have an existing spread sheet which has 2 tabs. Tab 1 has all components available for use ..... here we type in number of each component we wish to deliver. Tab 2 is a summary which filters out items with blank number to deliver.

What I want to do is add new components ..... simple enough I can do this ok on Tab 1 but I know I have to do something on Tab 2 to enable the new row to be read when filtering ...... this is the thing I can remember where to find / how to do

Thanks in advance

[TMS]

Suggest you post a sample workbook.

To attach a sample workbook. 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.

[O'Shea]

I have added a stripped out version of the worksheet

[O'Shea]

anyone able to help

[TMS]

As far as I can see, you need to unprotect the Catalogue sheet, if it is protected, and add new entries at the bottom of the list. It's a very simple link formula in each cell on the Quantities List. For example,

Please Login or Register  to view this content.

At the moment, there are no values in row 595 and beyond so you get zero returned in all the cells.

Note that, if you INSERT rows on the Catalogue sheet, the formulae on the Quantities List will auto adjust. You'll need to go to the first row and re-copy the formulae down to the bottom.