Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with workbook
hello everybody. I have a couple of questions I would like to ask:
I have this workbook. It contains 24 sheets named like this: jan09 - jan09GW - feb09 - feb09GW etc (These will change in 2010). I would like to make a form to input data. The form has 4 text boxes. Whatever is in box 1 goes in both sheets, what's in box 2 goes to the GW sheet, what's in box 3 goes to the other sheet and box 4 has the month I am working on. Now for my question: is it possible to have to box "understand" which month I need the data to go to (say I input January - the data I input should go to Jan09 and Jan09GW). Furthermore is it possible to create a macro that gives me a total of all I input and that put the result 2 cells below the last value (and maybe the word "total" in the cell next to it). I am not sure I have explained myself clearly... but I do hope so. thanks in advance for any help you can provide me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows. | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |