Sort data into a separate worksheet using a template

[duncande]

My unit works with several spreadsheets with similar types of information. They all have a recipient, financial coding, calculations of budgets and amount funded. We often use a template in excel and enter vlookup functions in each of the cells then print them one by one. We have over 150 recipients so this can be time consuming.

I attached a scaled down version of a spreadsheet we often use. Is there a way I can use a macro to automatically sort the data by recipient on each tab using a template? I'm not that familiar with macros so I've been unable to get it to work.

[JBeaucaire]

This little macro will do that.

Please Login or Register  to view this content.

I attached that to the button on your template, click and it will print all the codes from the other sheet.

[duncande]

This works great. Thank you for the macro. We can definately use this for a lot of our spreadsheets. Is there anyway we can print to creat pdf's?

[JBeaucaire]

Make your PDF printer your default printer and it should work as is.