Pete
06-09-2008, 04:12 AM
Need a macro that will copy cut and paste with (cut mode of and screen updating off) the data from B5:BA95 (worksheet Pricing Summary).
If the list grows beyond row 95 then allow for the increase in new supply customer details when copying and pasting.. to the demand table (see row 102 and beyond)
Less:
The Tricky Part - I do not wish to copy any part of column E for the Supply Table ..as these named ranges will be different to the demand table part
Copy and paste this information into the Demand Table minus Column E.
Point to note that the position of the Demand table will move as customer are added to the bottom of the supply table list or as customer are deleted.
Via the Assign Macro button
If the list grows beyond row 95 then allow for the increase in new supply customer details when copying and pasting.. to the demand table (see row 102 and beyond)
Less:
The Tricky Part - I do not wish to copy any part of column E for the Supply Table ..as these named ranges will be different to the demand table part
Copy and paste this information into the Demand Table minus Column E.
Point to note that the position of the Demand table will move as customer are added to the bottom of the supply table list or as customer are deleted.
Via the Assign Macro button