Automatically transfer information from a Raw data sheet to Report sheets.

Hi All,

Each month I have to do a report for various clients for their sales of ringtones. At the moment, I take the information from the 'Raw Data' sheet and manually enter the information into the 'Report' and 'Sales Breakdown' sheets. What I would like to know is would I be able to automate the data in the 'Raw Data' sheet so that it automatically completes the 'Report' and 'Sales Breakdown' sheets.

I attach a copy to hopefully explain what i mean.

Cheers in advance.

This macro will create the Sales Breakdown report. You haven't provided enough sample data to fully attempt the Report, apparently there is a whole section "T" type codes that have to be addressed, you've shown no example nor explained/demonstrated how to report them.

Please Login or Register  to view this content.

Also, I put some "rough match" code in the part to get the MCPS code, but there are variations in spelling, too, that you will have to repair in the data. Perhaps put in versions in the chart that have the alternate spellings...like "Fathers" and "Father's"

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.

I changed title for you so you can see what kind of title we are looking for... this makes searching/finding subjects easier for others...when googling.

1. Open up your workbook.
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet.

Now press F8 and select MakeReports from the macro list.

This macro will clear the contents of the existing Sales Breakdown sheet and replace it with the items on "Raw Data", then add the matching MCPS code as best it can.

No. Would you like the "totals" on the Sales Breakdown to be added by the macro? This adjusted code will handle that.

Please Login or Register  to view this content.