keilah
04-24-2008, 04:42 AM
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.
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.