Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2021, 09:06 AM
applecust applecust is offline Formula to copy specific cells if a match is met Mac OS X Formula to copy specific cells if a match is met Office 2001-2004 for Mac
Novice
Formula to copy specific cells if a match is met
 
Join Date: Feb 2021
Posts: 2
applecust is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Example.xlsx (13.5 KB, 14 views)
Reply With Quote
  #2  
Old 02-24-2021, 05:42 AM
Purfleet Purfleet is offline Formula to copy specific cells if a match is met Windows 10 Formula to copy specific cells if a match is met Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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)
Reply With Quote
  #3  
Old 02-24-2021, 05:59 AM
p45cal's Avatar
p45cal p45cal is offline Formula to copy specific cells if a match is met Windows 10 Formula to copy specific cells if a match is met Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

In the attached, on the Result sheet, right-click the table and click Refresh to update.
The result is an awful layout.
Attached Files
File Type: xlsx msofficeforums46532Example.xlsx (26.7 KB, 6 views)
Reply With Quote
  #4  
Old 02-24-2021, 06:29 AM
Purfleet Purfleet is offline Formula to copy specific cells if a match is met Windows 10 Formula to copy specific cells if a match is met Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Nice work with PQ, but agree looks Terrible!
Reply With Quote
  #5  
Old 02-24-2021, 08:03 AM
applecust applecust is offline Formula to copy specific cells if a match is met Mac OS X Formula to copy specific cells if a match is met Office 2001-2004 for Mac
Novice
Formula to copy specific cells if a match is met
 
Join Date: Feb 2021
Posts: 2
applecust is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
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)
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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Formula to copy specific cells if a match is met Question about Index match formula to copy all of cells in row dmcg9760 Excel 1 11-08-2015 01:41 AM
Formula to copy specific cells if a match is met Match Multi Cells gdavey Excel Programming 1 09-06-2015 11:09 AM
Formula to copy specific cells if a match is met Excel Formula: return a range of cells that match tinfanide Excel 4 08-30-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft