#1
|
|||
|
|||
Formula to copy specific cells if a match is met
Hello, I need help! I have a spreadsheet with multiple rows of data that I need to copy specific cells to another tab in a certain order as long as 1 cell in each row matches. I know I'm not explaining this well so I hope my example helps. I need to have the information merged together by the PO number in the first column into a single row by PO. Not sure if this is possible or not. Any help is much appreciated. |
#2
|
|||
|
|||
Probably best done with VBA as formulas would be messy, but i need to ask......
.... why do you want it like that? you will end up with a spaadsheet 3 or 4 pages wide (if not more) |
#3
|
||||
|
||||
In the attached, on the Result sheet, right-click the table and click Refresh to update.
The result is an awful layout. |
#4
|
|||
|
|||
Nice work with PQ, but agree looks Terrible!
|
#5
|
|||
|
|||
Thank you, I need the information in a lateral format to then do a mail merge so that each PO is on one sheet with each title associated listed. I use a MAC and everything I've searched to do this only works with a PC. If anyone knows a better way, I would appreciate it! Pulling my hair out at this point.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I transfer specific data from email to specific excel cells? | Mauro | Outlook | 1 | 11-11-2019 09:17 PM |
Linking Specific text fields in PP to specific cells in an Excel table | GWRW1964 | PowerPoint | 0 | 02-26-2018 07:37 AM |
Question about Index match formula to copy all of cells in row | dmcg9760 | Excel | 1 | 11-08-2015 01:41 AM |
Match Multi Cells | gdavey | Excel Programming | 1 | 09-06-2015 11:09 AM |
Excel Formula: return a range of cells that match | tinfanide | Excel | 4 | 08-30-2014 07:03 AM |