Vlookup value Offset

Hi,

Not sure if there is the way, but ill try the luck

What i want to do is =VLOOKUP(1,A5:E1500,2,0) the lookup value in this case "1" to offset to up one row or two, up to 7 lets say and extract the data from the row.

dfdfdfdf.JPG

Not sure if its possible to do or maybe is there other way not using vlookup, would be really helpfull.

Thanks

Im sorry maybe wasn't clear what I want to do

From column "B" up to "K" for same supplier the information will be the same and in "L:O" will be different. So if in column "A" I will put "1" the data will be transferred from sheet1 to sheet2 in relative cells and after that printed, but for each different PO* number should be printed separately with Supplier information, meaning that in column "A" the "1" moves down until reaches the next supplier and all the same.
The lookup option would work if I repeat data in columns "B:K" but would like to avoid it.


See attached please I hope will be more understandable.
Thanks

Originally Posted by Special-K

This is a bit too complex for my VBA knowledge.
Hopefully someone will come along and solve the problem.

Thanks for reply.

Any other thoughts, anyone?

Did not know where the value of "Lates" in Column H needed to go.
You'll have to get rid of all the Wrap Text / Merge & Center formats. Use Center Across Selection instead.
If you want to, you can use the following code to do that while Sheet 2 is the Active Sheet

Please Login or Register  to view this content.

Save this file in a folder and run the "AAAAA" code with Sheet1 active.
If all goes as anticipated, it should print pdf's into the same folder as where the workbook has been saved.
You can change it to print to a printer or just print the pdf files.
Have a look and let us know.

jolivanes that is amazing almost what I need . I have been analyzing it and tried correct it to make it work my way but not getting in full working order.

There could be two ways to make it:
1st. If I put in the row number 1 and tick the box in column "R" it will print the pdf, just for that PO in with the all data, not all 8 POs in one time. Like you can see it works just for first supplier, after it picks up same suppliers info :/

2nd could be the most preferable to remove column "A" and to have macro just to tick the box in column "R" and copy will be printed again just for the that PO, but not sure if this even possible code

For the questions answers are:
That's design for now with the 8 POs with the possibility to be less or more in the future. In on time the POs can be min 1 up to all 8 and yes all the POs are not repeatable.


Really appreciate and thanks in advance.

Just a suggestion.
If you only want to print one P.O. at the time, would this (see attached) not be easier.
I think in the future you're going to regret the use of 65 checkboxes in Column G
Right now their names are in no particular order and I am not going do it all over for you. That's your job.
BTW, If you want to save the files, as it currently does, you need to remove the characters it can't handle in file names.
Click on the "Get UF" button and you'll see.
After all the supplier names are without illigal characters, click again on the "Get UF" button to slect a P.O. to print.

Please explain what you want. Remember, you know what you have in mind, we don't.
You mention a field. What is a field in your mind?
Tick the box and print this booking papers. The checkbox is for 8 rows so which row?
Row 5 to 12 is not necessary. That is all there is for this particular supplier.
Etc etc
The only way I can help anymore is if you take the time to mention everything you do and what the result should be. Item by item.
BTW, the attached is different from the previous attachments also.

This is from 6 posts ago.
You'll have to get rid of all the Wrap Text / Merge & Center formats. Use Center Across Selection instead.

In your last attachment, if you have a 1 in cell A5 and you click on the checkbox in cell W5, do you want to print POs for all the data in rows 5 to 12?
The data in columns B, D, F, G, H, I, J and K in row 5 repeats in every PO?
The changing data will be the data in columns C, E, L, M, N, O, P, Q, R, S, T, U and V?

Same for cell A13 and the checkbox in cell W13? Print POs for all the data in rows 13 to 17?

Originally Posted by jolivanes

In your last attachment, if you have a 1 in cell A5 and you click on the checkbox in cell W5, do you want to print POs for all the data in rows 5 to 12?
The data in columns B, D, F, G, H, I, J and K in row 5 repeats in every PO?
The changing data will be the data in columns C, E, L, M, N, O, P, Q, R, S, T, U and V?

Same for cell A13 and the checkbox in cell W13? Print POs for all the data in rows 13 to 17?

Yes the idea was that.
I managed to do what i need with yours first macro, found out how it works and changed it .
Thanks again for your help.

Good for you.
So all is well and this thread can be closed.
Good Luck.