help with excel workbook

[Mauro]

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

 

[rajan deshpande]

Hi This can be done with If formulae. If it is possible for you to give a sample file.
rajan deshpande



Mauro wrote:

help with excel workbook
03-Nov-09

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 t
make a form to input data. The form has 4 text boxes. Whatever is in box
goes in both sheets, what is in box 2 goes to the GW sheet, what is in box
goes to the other sheet and box 4 has the month I am working on. Now for m
question: is it possible to have to box "understand" which month I need th
data to go to (say I input January - the data I input should go to Jan09 an
Jan09GW). Furthermore is it possible to create a macro that gives me a tota
of all I input and that put the result 2 cells below the last value (an
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

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Session Variables - Hijack
http://www.eggheadcafe.com/tutorial...b1-c5283d523c8c/aspnet-session-variables.aspx