Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help in writing a macro
I'm a newbie to VBA and I'm trying to write a macro hopefully some of guys
can help me out. In this spreadsheet, I would have two worksheets: The main sheet (sheet 1), and the sheet that only has a list of numbers (sheet 2). Sheet 2 has a list of about 25 numbers going down column A ie: A1= 45100 , A2=45200, A3=64250, etc... When I execute this macro, what it would do is go to cell B5 of Sheet 1, then place the first value of the list of numbers from Sheet 2 into B5(Sheet 1), then perform a manual calculation (F9 key), and save the file with filename of the text value in B5. After the save, it would loop back again and advance to the 2nd value of the list of numbers..etc.. until the end of the list. I would greatly appreciate if anyone could help me with this task. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro writing | Excel Worksheet Functions | |||
Writing a macro | Excel Worksheet Functions | |||
writing macro | New Users to Excel | |||
Macro Writing Help? | Excel Programming | |||
Writing Macro | Excel Programming |