Sophie has attended:
Excel Advanced course
VLook Up/Pivot
Hi Martyn
Question 1
Is there anyway to V Look Up images. I have a master product sheet where the images relate to the product codes. I can sort and filter and they stay in the right place which makes me think they are embedded into the cell?
Ideally I want to be able to move the selection over to a new spreadsheet.
Question 2
I have a spreadsheet that I export form our accounts system, it tells me all overdue invoices by line (so one account can have 20 overdue invoices so 20 lines). I then turn it into a pivot table so I get a total amount summary by account. I then make a new tab with the notes per account and Vlook up into the column next to the pivot. I then want to filter things around and have the notes follow the pivot, is that possible? It is hard to explain over email! Maybe I can send directly to you to look at if it is not clear?
Thank you
Sophie Robb
RE: VLook Up/Pivot
Hi Sophie
Thanks for both questions.
It might help to send your files for your questions if possible.
Send to info@stl-training.co.uk and ask to forward to me
Thanks
Doug Dunn
STL