Command Button to Duplicate Sheet and Increase Values by 2%

[shergraves]

I need some help with some coding on a command button...

I want the command button shown in the below screenshot (Increase by 2%) to create a duplicate worksheet within the same workbook, and at the same time, increase the value of the fields highlighted in the screenshot below by 2% each.

Can anyone help me with how to code this to do what I want it to do? It is very much appreciated!

Rates Screenshot.jpg

[sintek]

Hi shergraves...
Give this a go...Adapted from RoyUK

Please Login or Register  to view this content.

EDITED: My apologies, I noticed an error in code and have rectified....

[shergraves]

Hi Sintek,
Thank you for your quick reply! When I enter the code below, as pulled from your previous post (but to include U column), I receive an error "Runtime error 13: Type mismatch." When I click on debug, the code "cell.Value = cell.Value * (102/100)" is highlighted yellow. Thoughts? My code is below...

Please Login or Register  to view this content.

[sintek]

Column U contains merged cells so does cause complications...It does work however till Col T right.....
Upload a sample file and I'll work on rectifying to include Column U.

Originally Posted by Pete_UK

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

[sintek]

see amended code in Post 2 ...It works just changing T to U

Keep this line

Please Login or Register  to view this content.

[shergraves]

AHHH! I fixed it! Haha! In one of the last few rows, column U contained the value "N/A" which is what was throwing it off. It DOES work on the merged cells, however, so I believe I am good to go. Thank you again so much for your help! Saves me SO much time and effort!

[sintek]

Glad you got it working...Thanks for rep points