I was very unsure how to name this post cus it's hard to explain this is few words so just bear with me. I'm from Iceland so English is not my native language so excuse my spelling or vocabulary. I have been trying to get this for few days now and not gotten anywhere to be honest. I put my excel work in attachment for you to take a look, this excel sheet is in Icelandic at least most of the text but just ignore that. Also there is a Jpg made in paint to show it better what I'm trying to make here.
Okay let's begin, so I'm trying to get every thing to work together and with only few numbers in Verðbanki R-Column I get bot the price in Verðbanki T-Column, price, magnitude and sum in both Verðbanki and Reikningur.
As you can see there is a formula in the file that says.
=IF(ISNUMBER(MATCH("x";$W$8:$W$14;0));INDEX($J:$P;ROW();MATCH("x";$W$8:$W$14;0))*R8;"")
It says: If there is x in W8:W14 then number in J:P Row * R. So if I put X by "Egger" and go to row 15, type 3 in R15 then T15=J15*R15, but if I had put X in "Sprautað" the T15=N15*R15.
That is all done now but now I'm trying some new stuff.
What: If there is X in e.g. "Sprautað" and type 1 in R8 then beside this above I want just part of the "Verðbanki 8-Row" to be pasted on a new sheet that is named "ÚtskriftKúni" and in the new line there is only the Name (B Column), Price (N8), magnitude (R8) and sum (T8). Also will there be frozen Rows that will have Type (here; N4) and some other data the is irrelevant. Than on a second sheet I'm trying to get the scales from sheet called "StærðirSprautað" to a new on called "StærðirSmíði" so if I have like 4-7 rows in R with numbers I only get this 7 boxes in the "StærðirSmíði" sheet.
The hard part is that I'm don't want the empty lines go come out, only the lines that have nr and that in a row. You can see that better on the jpg that is attached.
Question: Is this possible, if so any suggestions, a nudge in the right way.
P.s. If you don't understand want I'm asking for please tell me want it is and I'll try to explain it better. Also the hole excel file it not nearly done.
Bookmarks