VBA to perform like find / trim / copy paste InStr strMid Rng.Offset

[ZackPa]

Hello, I am very much a novice w VBA, my skills don’t go very far past having excel record/code the VBA based on my actions. I made an excel sheet for my government job in the past and I want to make another one to keep my name fresh as a good employee. My goal is to be able to use a VBA macro to paste from clipboard, then find a particular pieces of info, trim off excess data, perform a divide by three formula, replace quarter names with the corresponding months, and in the end paste the cleaned up info into columns. I have a picture of what a paste looks like taken from a database my government job uses. It gives a person’s wages quarterly and employer names. I want to be able to trim off all excess data and just see the months involved (quarters converted to months), the employer name, and the monthly amount for each employer (quarter total divided by 3). I have four young kids and I don’t have time to go real deep into teaching myself coding. I want to get ahead at my job and I’m asking for help on coding VBA for this. Please and thank you.

 

[purvi1601]

Hiii can you please help me with my query


Actually i have one excell sheet in which there are lots of columns but i have to copy the column with their name and paste into the another sheet along with the filter applied into it. How did i do that using vba.