computing
  • 68

Copy data from one sheet to another using VBA

  • 68

I have a report that I would like to be able to separate based on the Value of Column L. For example if Row 2 Column L = “P100278” then copy and paste the entire row into Sheet “Alpha”. The report is in Sheet “Source”

An example of some of the Values and relative Sheets are as below, noting some of the values relate to the same sheet:

Value: Sheet Name:
P100278 CPL Distance
P010129 CPL
P100279 SGT Distance
P010130 SGT
P100663 DENT SPVR
P103925 STM
P103274 STM
P103278 STM

I have browsed many other peoples questions and have tried to apply their answers to my problem however I keep getting stuck.

As I have many other values and sheets, a brief outline of how to add to the macro would be fantastic.

Any help would be much appreciated.

Share