| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro/VB Help Needed
Hello,
I need help with a macro I'm trying to use. I'm not even sure I can do what I want without VB (which I am nearly clueless at!) Anyone out there that can help? Here's my situation: I have a range (Glass Size!V33:AN33) that has formulae to calculate data. I am trying to record a macro to take the calculated information in this range and send it to a summary worksheet (Hardware!A3:S3) via a button assigned to the macro, which is in the same workbook. After the data has been updated in the summary W/S (Hardware!), I'd like the range on the Glass Size! W/S to be reset (but keeping the formats/formulae) and ready to calculate new figures, in turn ready to be sent to the next available row Hardware!A4:S4) etc. How can I do this? TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| MAcro Needed | Excel Discussion (Misc queries) | |||
| Macro needed to set macro security in Excel to minimum | Excel Programming | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Threaded Mode
