Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2018, 11:04 AM
jennyyoung jennyyoung is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 32bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 32bit
Novice
Creating a Master List from Multiple Workbooks & Keeping formatting
 
Join Date: Apr 2018
Posts: 15
jennyyoung is on a distinguished road
Default Creating a Master List from Multiple Workbooks & Keeping formatting

I am thankful I found this forum. I am stuck on something.



I am trying to combine data in 3 workbooks into a master list. Each of our inside sales people have a list of customers and orders they are working on. Status changes all the time and I want to create our manager a master list that will auto update on its own.

I tried the Consolidation feature but that didnt work because it only works on numbers not text.

I ended up just linking a RANGE from each file. As long as new orders are inserted somewhere between the first and last row of that range, it'll update the master.

The problem I am having is they have a color code system with a legend and the formatting isnt coming over from the source automatically.

If I go to the Workbook Connections Properties, there is a section that says OLAP and it has some options that seem to be what im looking for but that section is grayed out.

Can someone recommend a way to gather data from 3 files and bring the formatting over too?
Reply With Quote
  #2  
Old 04-30-2018, 12:49 PM
NoSparks NoSparks is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 64bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
The problem I am having is they have a color code system with a legend and the formatting isnt coming over from the source automatically.
Is this Conditional Formatting in the source(s) ?
Reply With Quote
  #3  
Old 04-30-2018, 01:00 PM
jennyyoung jennyyoung is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 32bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 32bit
Novice
Creating a Master List from Multiple Workbooks & Keeping formatting
 
Join Date: Apr 2018
Posts: 15
jennyyoung is on a distinguished road
Default

No, they are just highlighting rows. Not conditional.
Reply With Quote
  #4  
Old 04-30-2018, 07:30 PM
BobBridges's Avatar
BobBridges BobBridges is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 64bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Preliminary question: I'm assuming that each of the three salespeople have their data on a separate worksheet of their own. Do you want the master list for the boss to be three worksheets in one master workbook, or all combined in one worksheet with some kind of header row for each salesperson?
Reply With Quote
  #5  
Old 04-30-2018, 11:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 64bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

On this page there is code for merging sheets which retains formatting.
There are other examples here
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 05-01-2018, 07:53 AM
jennyyoung jennyyoung is offline Creating a Master List from Multiple Workbooks & Keeping formatting Windows 7 32bit Creating a Master List from Multiple Workbooks & Keeping formatting Office 2010 32bit
Novice
Creating a Master List from Multiple Workbooks & Keeping formatting
 
Join Date: Apr 2018
Posts: 15
jennyyoung is on a distinguished road
Default

the boss wants to be able to view one sheet with all the data with a header row.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Master List from Multiple Workbooks & Keeping formatting Pull the data from different closed workbooks paste into master vba manilara Excel Programming 2 11-19-2015 08:41 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting hanvyj Excel Programming 0 08-28-2015 01:15 AM
Creating a Master List from Multiple Workbooks & Keeping formatting Creating multiple list styles for a document Ulodesk Word 2 07-22-2015 11:58 AM
Linking Workbooks/Entire Worksheets to Identical in Master taxacct Excel 2 10-01-2014 11:22 AM
Creating a Master List from Multiple Workbooks & Keeping formatting Access to Word, Creating a list from multiple records daymaker Mail Merge 9 03-14-2012 06:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 PM.


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