Developing a macro using pivot tables, sum function and vlookups

[edunne]

Hi,

Is it easy to develop a macro for the attached please?

The first 4 tabs (all sales, rebate wk, rebate mth, rebate YTD) will be input/saved first. Then it's time for the macro I think.

The steps are as follows:

Create '2014 Net' by using cells A to I in 'All sales' tab. See '2014 tab' for pivot table format.

Copy and paste information from pivot table into columns F to I.

Rename columns:
F Cust Grp 1
G Wk Gross
H Mth Gross
I YTD Gross

In each of the rebate tabs, i need to create a pivot table to include column M to P. Row labels being column P and Values being column M.

going back to the '2014 net' tab. I need to create a 2 spaces between each figure i.e. (see 'spaces' tab as an example). I would like this done on the '2014 net' tab.

columns now to be called:
F Cust Grp 1
G Wk Gross
H Rebate Wk
I Wk Net
J Mth Gross
K Rebate Mth
L Mth Net
M YTD Gross
N Rebate YTD
O YTD Net

Column H Vlookup to 'rebate wk' pivot table
Column K Vlookup to 'rebate mth' pivot table
Column N Vlookup to 'rebate YTD' pivot table

Calculation: in cell I (G minus H) in cell L (J minus K) and in cell O (M minus N)

That's it! Hope you can help or am I asking the impossible!

Thanks

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[edunne]

Title has been changed to be more specific.

Thanks

[nathansav]

http://www.automateexcel.com/2004/08..._from_a_macro/

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[edunne]

http://www.automateexcel.com/2004/08..._from_a_macro/

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

Where do I even begin? I know nothing about macros! I don't even know where it is on the excel toolbar?! I need basics if that's ok?

I have attached the worksheet that i want to develop a macro for.

Thanks

[nathansav]

Have a look at google for the basics. You cant expect from scratch on this, this is for helping people not doing it for them.

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[edunne]

Have a look at google for the basics. You cant expect from scratch on this, this is for helping people not doing it for them.

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

That's a bit harsh - I am looking only looking for help on where to start...

[nathansav]

That is help on where to start. The title is beginning VBA in Excel 2010.

You'll have to do a bit yourself