Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-30-2016, 05:01 PM
jeffreybrown jeffreybrown is offline Creating a master spreadsheet for sorting information Windows Vista Creating a master spreadsheet for sorting information Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Look at this example and see if it is something you can work with.

On the Sheet1 tab, use the dropdown box in column I to select one of the choices.

Of the three choices, each choice has its own sheet.

When you select one of the three choice the row will be copied to the sheet that matches the choice.
Attached Files
File Type: xlsm Notsonerdy.xlsm (17.4 KB, 19 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a master spreadsheet for sorting information Macro to open Multiple files and copy information to a master file gbaker Excel Programming 2 04-08-2016 08:44 AM
One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Jo Freeman Excel 4 10-28-2015 08:09 AM
Creating a list and sorting alphabetically. irvsax Word 4 09-04-2013 11:47 PM
Creating a master spreadsheet for sorting information Creating a sorting method. Balliol Word 2 07-25-2013 06:18 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. psmaster@earthlink.net Excel 0 11-24-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:17 AM.


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