Generating leadsheets

[shakethingsup]

I have a workbook in which I will have multiple tabs.

Tab 1 looks like this. Let's call this Tab - ALL. The common thread is the group name:

I will create a second tab called "cash" and have a A1 also be called "cash"

I want to then prepopulate this second tab with all accounts, descriptions and amounts that match "cash"

I will then do that for AR, Prepaid and so forth.

My current solution in the cash tab:
=IF($A$1='All'!$A1,'All'!B2)

This pulls in 1110. I just copy the formula into the next cell and so forth and it pulls in the description and amount. I can drag it down. When it doesn't find a match, it outputs FALSE and I know to stop.

Any other way to do this?

Thank you

 

[JLGWhiz]

You could filter and copy, either manually or using vba/vbScript. But I am not so sure the formula you posted is the best for the job. I think I would use something like

=IF($A$1='All'!$A2,'All'!B2)

to get the corresponding account for each matching transaction type.

 

[My Aswer Is This]

Try this Vba script:

Sub Copy_From_All()
Application.ScreenUpdating = False
Dim i As Long
Sheets("All").Activate
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
    For i = 2 To Lastrow
        Rows(i).Copy Sheets(Cells(i, 1).Value).Rows(Sheets(Cells(i, 1).Value).Cells(Rows.Count, "A").End(xlUp).Row + 1)
     Next
Application.ScreenUpdating = True
End Sub

 

[shakethingsup]

If I only knew how to code in VBA, use VBA.

Which leads me to another question.

Any virtual classrooms or resources for people to learn VBA for beginners? Basically online school for this?

 

[shakethingsup]

Thanks - yes that makes sense for account. Thanks!

 

[JLGWhiz]

If I only knew how to code in VBA, use VBA.

Which leads me to another question.

Any virtual classrooms or resources for people to learn VBA for beginners? Basically online school for this?

There are numerous tutorials on the web. Just type 'Free VBA Tutorial' in your web search box and click 'Go'. It will bring up several options. You can also learn by reviewing postings on this site.

 

[My Aswer Is This]

Are you saying my script did work did not work or you do not know how to run the script?

Thanks - yes that makes sense for account. Thanks!

 

[shakethingsup]

My answer is this, I'm saying I don't know how to run it yet. I will learn over the next week