Can a macro transfer data to tabs with same name found in column of master sheet?

I started with the code below and it was finished by Mumps1 (thanks again). I’ve been researching the forum/web and reading but can’t find what functions would help with the next part of this report.

The code below looks at column “D”, creates tabs for each unique value and names columns.

The next goal is to fill in the tabs created with the values from the master tab. So if you look over “Sheet1” you will see the first rows should go under tab “123456”. Here is the tricky part:

Sometimes the account number found in column “D” will be found in column “K” or “M”. If the account number in column “D” equals the account number in column “K” then the amount should be placed under debit. If the account number in column “D” equals the account number in column “M” then the amount should be placed in the credit column.

I can’t find anything like this on the web so I’m not sure if it’s even possible. Any guidance is appreciated.

Please Login or Register  to view this content.

*Separate question – I tried to change this:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

and got errors, know why?

HTML Code: 

and got errors, know why?


When you put something in quotes "", the program looks for that text string as worksheet name. It looks like you are trying to make that a variable. You may want to declare a text string i.e. actwks and add

somethind like,
actwks = ActiveWorkbook.Activesheet

then use

HTML Code: 

I am not sure about the syntax.
It may have to be

actwks = ActiveWorkbook.Activesheet.name