Copy worksheet with specific name and no blank cell in a specific range

Hello,

I need to create a macro to copy my active sheet and rename the new worksheet with the cell name in R1.

Also I have some data/formulas in the range C9:K396 (name Manager "FORMM") that I wish to copy but only without blank cells.

Is it possible to manage both action in a same macro?

Thanks,
Graig

I have attached a sample file. So I need to copy the "Current" workbook and rename with the cell R1.

In the copied workbook (refer the workbook "user1"), I need to remove the R1 cell + the remove the macro buttons and remove in the range name manager (FORMM) the blank or "0".

I only reproduce the range C9:C396. I need to remove the 0 and blank cell in the entire FORMM name manager.

Please let me know if you need further information.
Graig

Please Login or Register  to view this content.

That will copy your sheet. I don't get what you mean about not copying blank cells, if it is a blank cell it will be copied as a blank cell...

Do you mean you want to delete any formulas that return "" or 0 on the new worksheet?

Correct! I need to get a report without blank cells or cells equal to 0.

As you can see in the worksheet "consult" I would like to get ride off the cells B10:12, B23:24, B28 and B32:35 as per the example below "INFOSAMPLE1" C8 cell.

In the cell "user1" I have no "0" or blank cells.

I hope I am clear enough in my explanations! If not let me know!
Thanks,

PS: I have a bug in the line:

HTML Code: 

Please Login or Register  to view this content.

Thanks.
the worksheet is properly copied with the correct name. However I still have blank and 0 in the range "FORMM" and the buttons "Reset" & "New Macro" still appear in the new workbook

Hi, sorry, it's difficult for me to investigate because your worksheet doesn't port well to 2003 (the formulas all use non 2003 functions).

I'd suggest using the macro recorder to delete your buttons and see what output you get. The bit to delete the 0's looks ok to me though, unless the named range isn't being copied in which case you could try changing Range("FORMM") to Range("C9:K396").

When I go on record a macro from the copied file I get that:

HTML Code: 

and it does what I need. I just don't know how to implement that macro with yours! :-(

Well I am using the first macro:

HTML Code: 

And once I ran the above macro I need to go to the copied macro and run the below one to get exactly what I need.

--> I would like to execute automatically the below script when running the first one.. to avoid manual action.. Is it possible?

HTML Code: 

Many Thanks,
Graig

Please Login or Register  to view this content.

Yeah that would do :-D do you know how to remove the insert shapes though in the copied workbook only?

Done

HTML Code: 

thanks!