PC Review


Reply
Thread Tools Rate Thread

Best way to populate worksheet from 2 combo boxes

 
 
jswasson
Guest
Posts: n/a
 
      7th Jul 2006
I am creating a rate sheet that currently uses just one combo box and "if"
formulas.
Rates are A, B, C, D, E and the formula is
=IF($J$3=1,Data!$C$2,(IF($J$3=2,Data!$D$2,IF($J$3=3,Data!$E$2,IF($J$3=4,Data!
$F$2,IF($J$3=5,Data!$G$2,IF($J$3=6,Data!$H$2,"")))))))

J3 is the output from the Combo box.
I have 81 products that are listed on the Main worksheet, each with this
formula so that when a Rate is choosen from the Combo box then it populates
the Main worksheet with the appropriate data.

All of this works beautifully. Until....

I currently have the rates calculated on a weekly bases, but there are some
clients that need to be bi-weekly, or bi-monthly or even monthly.

So.....
I wanted to create a 2nd Combo box and have those 4 options. Use that data
from that combo box in conjuntion with the data from the first combo box to
populate the worksheet.

I created an IF formula, but by the time I got it all in like I needed it,
Excel said it was too long.

I know that I could create 4 different worksheets one for each of the "time"
varable, but I would like for it all to be on one sheet. (I am catering to
the least common demoniator in the office )

I have looked the the postings and couldn't really find anything that matches
this problem.

Here is what I got right now:
http://www.oakhillphoto.com/6ClassRateSheet.xls

If there is a better way to do this I am willing to learn.

Thanks in advance.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Combo Boxes using Form_Current James D Smooth Microsoft Access Forms 1 8th Dec 2008 02:40 PM
*** Using DataReaders to populate combo boxes - please help!!! *** ricardo.dapaz@gmail.com Microsoft VB .NET 2 3rd Aug 2006 12:13 AM
Populate combo boxes from results of other combo boxes matt.pimm@gmail.com Microsoft Access Forms 1 13th Jan 2006 02:47 PM
Combination of 2 combo boxes to populate 3rd =?Utf-8?B?QUo=?= Microsoft Excel Programming 2 31st Jan 2005 10:55 PM
2 combo box, 2 txt boxes - Populate problem S Jackson Microsoft Access Forms 5 7th Dec 2004 09:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:57 AM.