#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
No, they are just highlighting rows. Not conditional.
|
#4
|
||||
|
||||
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?
|
#5
|
||||
|
||||
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 |
#6
|
|||
|
|||
the boss wants to be able to view one sheet with all the data with a header row.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 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 |
Access to Word, Creating a list from multiple records | daymaker | Mail Merge | 9 | 03-14-2012 06:37 AM |