Solved: Macro to keep data in tables in order

[keilah]

See attached workbook.

Hi Experts

Looking at worksheet Deal Selection Columns(s) B and I

Applying requirement to both column(s)

If the user deletes any supply customer deletes from column B then move up and compress

Supplier data in column b and also data in range C:G

But do not move or change the shape of data in column I:M keeping this the same

Also maintain the table length from B9:B58

Likewise if we delete any demand customer repeat the above steps &.. Delete and compress data column I but do not change the data in column B.

Can this be done without clicking a macro button???????

A pop up window appears telling the user that you are about to remove/delete supply or demand customer xyz, click to proceed.

[mdmackillop]

Hi Keilah,
Please read this (http://www.excelguru.ca/node/7).
It appears you are cross-posting heare and at Experts Exchange, without giving links at either location. If you continue to do this, you may be suspended or banned from the site.
MD

[lucas]

Hi Keilah, Please post your solution for others searching the forum with the same problem......