I sell windows for a living and would like to take the pricing information from my price book and create a spreadsheet where i can capture the information and put it in another table.
For example, this would be the information provided by my supplier and the spreadsheet I put together below. As you can see, the price depends on the widths in the columns and the cooresponding heights in the rows.
pic.jpg
hi rayzorkat, thats a pretty picture. however, i doubt any1 here is willing to retype your data for you, so i would suggest that you upload a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok, let's try this. The "Price Book" will contain my prices. I want to be able to input the width, height, and type on the "Input Sheet" and capture the cooresponding price from the "Price Book." Does that make sense?Window Spreadsheet.xlsx
The width 24 does not match any width in Price Book (32,36,40,48), also the height 44 vs (25,28,32,36,42)
Which value would you like to get for width and height in this case?
Quang PT
Sorry about that. Let's just pretend those numbers are less than that. Just throw something out there.
Basically, the widths and heights from the Price Book are "up to," meaning a 35 inch wide window would fall in the 36 inch category. So a 35 inch wide by 37 inch tall casement should be $440.64. Just trying to figure out how to get that to automatically generate.
Sorry for the confusion. I appreciate your help.
Here's a reworks workbook with better numbers.Window Spreadsheet.xlsx
Last edited by rayzorkat; 01-02-2013 at 08:42 PM.
...deleted due to bad solution...
Don't do things when in haste.
//Ola
Last edited by olasa; 01-03-2013 at 10:14 AM. Reason: Deleted due to bad solution
Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
It saves time, to skip already solved threads.
..........
Last edited by bebo021999; 01-03-2013 at 10:01 AM. Reason: duplicate post
Try this in G3:
Confirmed with Ctrl-shift-enter rather than enter only
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks