VBA to copy and Clear

MrRosco

New Member
Joined
May 12, 2016
Messages
47
Happy Friday everyone :)

I need some help with a little project I'm working on and need some VBA code to maximize the document. Here is what i need.

1. once the form is completed i have created a summary cell with Key info that has been CONCATENATED, These can be found in cells A58:A90. Each entry will have an undefined number of rows added.

2.Once data entry is complete i have added a Button to the document for them to press which will transfer the data to the tracking sheet

3.After the above has been completed i need the document to clear ready for the next entry.

the information will be coming from the sheet "PCF 2016" and Transferred to "PCF TRACKING"

The cells that need clearing are on "PCF 2016" are C5 J5 B12:B50 E12:E50 F12:F50 K12:K50


Any help from you fine people will be greatly appreciated :confused::confused:

Rosco
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Dim MyCells as Range

Set MyCells = Range("C5,J5,B12:B50,E12:E50,F12:F50,K12:K50")

MyCells.ClearContents

Set MyCells = Nothing
 
Upvote 0

Forum statistics

Threads
1,213,507
Messages
6,114,029
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top