Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP with complicated macro
I have over 50 sheets in my workbook; each sheet contains a recipe, with new
ones being Added all the time by users, each sheet is identical, only the data is different. What I need is to have a master list, with the name of each recipe, and also certain cell information, i.e. recipe name, recipe cost, recipe yield etc. Since recipes are added and updated all time, I would like to add a button that would trigger the macro to go out search for the information and add it to the master list, always adding after the last row, Once that is done I want to be able to sort the list by a certain heading (recipe name). Also need to know what happens if a sheet is deleted and the master is updated, will it just remove the information from the master list? The final look of the sheet needs to be like this NAME COST YIELD Lasagna $4.50 25 Pizza $3.50 8 Spaghetti 5.00 3 Hopefully someone can figure out how I can do this, your help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |