Automatic row addition

**Henry Kolding** · 09-02-2010, 05:06 AM

Hi,

I have in the workbook three sheets namely Output, Quantity and Database. I need help in which whenever I add an item in Database sheet, e.g. in between row2 and row3, the same will be automatically added in both Output & Quantity sheets exactly in the same row. Currently i'm doing it manually whereas it will not be practical as it will be huge database. The method can be either by default excel function or macro/vba.

Thanks.

Test Model 3.xlsx

**snb** · 09-02-2010, 05:45 AM

What is the advantage working with 3 lookalikes ?

**Henry Kolding** · 09-03-2010, 09:30 AM

Hi,

Actually they are different and each sheet has its own function but deals with the same subject in the Database. I've removed the formula and details so that it looks simple but i wasn't aware that it has becoming lookalike.

The rational is that whenever i add a new item in between the row in the Database sheet, the item will appear in the other two sheets on the exact row as the Database's.

**snb** · 09-03-2010, 09:44 AM

You can make as many different worksheets as you like using the same database worksheet. You can refer to the databasesheet wiht 'database!...'

**Henry Kolding** · 09-24-2010, 08:20 AM

Hi,

Thanks for the idea. However it still does not achieve my target as whenever I delete one item in the Database sheet the rest of the sheets will look like below:

P1c.jpg

Ideally, what i'm looking for is something like whenever one item in Database sheet is removed , the item in the rest of the sheets will also dissappear. The result should be like below:

P2c.jpg

Attached here is the updated file.

Test Model 3_2.xlsx

Any idea is welcomed. Thanks.