kamuk000
04-12-2013, 02:51 AM
Hi all,
I really hope that there is someone who can help me, because I am very pressed in school.
The program must be susceptible to more and fewer Ansvarlige (responsible). See pic and xlsx.
Step 1: Delete Merge, delete blank cells, delete Tilbud (offer) in Projektgruppe(project group).
Step 1B: Delete rows 1 to 17 and copy row 18 to other tabs (headline).
Step 2 InputBox with keying after Ansvarlig (responsible), and then cut row to new tab per responsible.
Step 3: Sort by Projektgruppe (project group) - service trades, AbonER, Abonnement, EntrepFP.
Step 4 Keep Afsluttet (Finish) - Delete all Igangværende(in progress), ServiceER, AbonER, Reklam, Tløntid.
Step 5 Sum after Projektgruppe(project group) in each tab. I need Omsætning (revenue) and DG%
Step 6 Cut the result (sum) for summary tab for Ansvarlig (Responsible) and Projektgruppe (Project group).
Thank You very much :doh:
I really hope that there is someone who can help me, because I am very pressed in school.
The program must be susceptible to more and fewer Ansvarlige (responsible). See pic and xlsx.
Step 1: Delete Merge, delete blank cells, delete Tilbud (offer) in Projektgruppe(project group).
Step 1B: Delete rows 1 to 17 and copy row 18 to other tabs (headline).
Step 2 InputBox with keying after Ansvarlig (responsible), and then cut row to new tab per responsible.
Step 3: Sort by Projektgruppe (project group) - service trades, AbonER, Abonnement, EntrepFP.
Step 4 Keep Afsluttet (Finish) - Delete all Igangværende(in progress), ServiceER, AbonER, Reklam, Tløntid.
Step 5 Sum after Projektgruppe(project group) in each tab. I need Omsætning (revenue) and DG%
Step 6 Cut the result (sum) for summary tab for Ansvarlig (Responsible) and Projektgruppe (Project group).
Thank You very much :doh: