Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a formula, function or macro that accounts for shading of a cell or row?
I've been given a spreadsheet but the trouble is that it's not a "real"
tabulated "row by row" account. See example he http://digitaltoast.co.uk/zen/prods_example.xls I'd have to make the formula, then get busy with copy and paste, UNLESS I can find some sort of macro which says "IF this line is shaded THEN do this to the next shaded line down UNLESS the product code is the same except for the extension, in which case make it an attribute of the parent product". Which I don't THINK Excel/OpenOffice can do. I might be wrong. In other words, concat a3,b3,c3,d3,e3,f2 concat a4,b4,c4,d4,e4,f2 concat a6,b6,c6,d6,e6,f5 concat a7,b7,c7,d7,e7,f5 skipping a5 etc because it is the one in grey, BUT using f5 in each of the NON grey ones, BECAUSE it is in grey. Of course, I have no idea why the supplier are playing dumb about the actual database that drives the website - after all, they encourage resellers to use their price list. So I've given it another go, but we've been asking for literally months and "the IT guy" either never understands or never gets back to us! Which is why I wanted to reverse the webpage into a database (previous post) if this can't be done. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Help on Macro or Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Function Macro for Nested IF | Excel Worksheet Functions | |||
Macro Formula revision? | Excel Worksheet Functions |