Macro to function without deleting the existing formulas in the cell

Hello All,

I request for the help for the following problem:

In my Bill Sheet I have Columns for ProdID Description Item Netweight etc etc

and I have created macro and assigned it to the Button Called "Add Details" you can find it in left side of the sheet, so when i have created macro which copies the data in bill sheet and pastes it over tblOut sheet under each column and it clears the content in Bill sheet, so i am requesting for help to do the same activity but without deleting the formulas in Bill sheet,(i have attached excel sheet, in that it is already copied data from B6 to L6 and pasted it in tblOut sheet, however it is deleted the formula in Bill Sheet, so please help me to do the same job witout deleting the formulas in Bill sheet.

Thanks
Pramod

I looked at your code and revised ti a little. How does this work for you?

Please Login or Register  to view this content.

Hi Morbdetro,

It works fine, it copies data from Sheet "Bill" to Sheet "tblOut", however data which is copied from sheet "Bill" remains there only, I want it to be erased the moment those data copied and pasted in other sheet but formulas should remain there.

Thanks

I see... I think I'll have something posted in a few hours when I take my lunch. So basically the number that starts with the "P" in column B I think? needs to be cleared?

How about this?

Formula:

Please Login or Register  to view this content.