Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and insert cell info macro help
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and insert cell info macro help
It would be a lengthly procedure to do but you can email me your list at
, I'll put a bit of code init and send it back, that would be a start ! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200603/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and insert cell info macro help
I will send you a sample so you can visulize what I am trying to do. The
attached workbook will be name Sample Recipes. Thank you "Crowbar via OfficeKB.com" wrote: It would be a lengthly procedure to do but you can email me your list at , I'll put a bit of code init and send it back, that would be a start ! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200603/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
How to embed an image withon a cell as opossed to copy and paste | Charts and Charting in Excel | |||
copying cell names | Excel Discussion (Misc queries) | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |