Creating a single Table with different formulas Excel VBA

[AaliyahN82]

Hi everyone! I just signed up today to ask for help from y'all. I am a newbie when it comes to VBA. Basically I am trying to create a single table with multiple formulas in it. I can't manually put the formulas because the list in the database sheet is dynamic.

What I am trying to do is this:

Categories can be found on the database sheet. Number format of sub categories depend on their respective formats which are indicated on the other sheets.

I haven't tried any macros at all because I am not sure where to begin. Here's a link to a sample file: sample file

Your gracious help is highly appreciated. Thank you so much

 

[AaliyahN82]

okay so here's what I have so far:

Sub testing()

Set Rng = Sheets("Database").Range("A1").CurrentRegion
Set Rng = Intersect(Rng, Rng.Offset(1))
MCategory = ""


For Each cll In Rng.Cells
    MCategory = cll.Value
 
  Set Destn = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Offset(1)
  With Destn
    .Value = cll.Offset(, 1).Value
  End With
Next cll
End Sub

I am only able to do the categories part, but I don't know how to do the formulas since they differ depending on whether it's for monthly/weekly and Main Category/Sub Category.

I am using Windows 10 and Office 365 if that's something you need to know.

PS: I also posted here at 7:38PM today: Creating a single Table with different formulas Excel VBA

 

[AaliyahN82]

Anyone?

 

[AaliyahN82]

hello?

 

[AaliyahN82]

Anyone who has an idea???

 

[AaliyahN82]

helloooooo?