LinkBack URL
About LinkBacks
please see attached , the formula in B8 works for 1 style , our price list has 52 styles is there a way to formulate this
please see attached , the formula in B8 works for 1 style , our price list has 52 styles is there a way to formulate this
Last edited by bdf1965; 01-06-2014 at 12:49 PM. Reason: INCORRECT TITLE
this is correct post
you could remove your references to sheet1 as they are redundant, but otherwise it looks fine to me
I just dont think it will fit for 52 styles , to many characters
How do you envision the formula changing as the value in B4 changes from 1 to 2 to 3 ?
You could probably use OFFSET() or maybe even range names if you have multiple tables like the 1 on sheet3?
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
Just the different values as the prices increase in other styles
Do the different styles all have the same headers (col A and row 1) or would they be different for each table?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If (sheet) 1 contain 'style 1' and
(sheet) 2 contain 'style 2' and
(sheet) 3 contain 'style 3' and
...
Try then this formula
You can also change the name of the style
change then the sheet name also
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
How would that equate into a formula please
see the formula in yellow cell 'Sheet1!B8'
will this work with the frame sizes that dont have the same amount of price options
You can try it.
If you take the max size, I think it does.
I do apologise I have just seen your reply , most would be different some a lot smaller and the increments starting from different values etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks