Apologies if the below is asking too much as I am a novice to VBA and trying to catch up quickly.
The below is the ‘embryo code’ generated from a recorded macro. Numerous attempts to edit this myself has caused various compile errors so I’m at my wits end.
Please help!!
The objective I want to achieve is to have a button that the user presses once they have entered data into columns l to V the data quantity is upwards of 300k rows each time so filters have been applied from columns A-K.
Once data is entered I want the code to find and replace specific references in column k which removes part of the text. In this example _yes, _no, _maybe. It’s safe to assume these variables will always be at the end of the text. I then want to make sheet two which is the pivot table which will be hidden to appear and refresh .
Then copy and paste special values all that data into a new sheet change ‘Key2’ values to be in a specific order and then copy and paste the data values and key amounts only (without headers) into a set template.
The stages up to this point are quite repetitive hence the need for the coding
There are various pivot tables that will need refreshing and data copied into different sheets relevant to each pivot table so any instructions you can add to the code to help me identify what i can modify would help.
The user will then have instructions of how to manually manipulate the set template only.
Bookmarks