Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows. minimaster Excel Programming 4 September 15th 09 11:47 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook burl_rfc Excel Programming 1 April 1st 06 08:48 PM
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? WimR Excel Programming 9 July 25th 05 12:44 PM
Copy a range of cells in an unopened workbook and paste it to the current workbook topstar Excel Programming 3 June 24th 04 12:50 PM
What commands do you use to name a workbook, save a workbook,open a workbook Steven R. Berke Excel Programming 1 July 24th 03 11:37 PM


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"