mjj28
asked on
Word feature
I have a user who has a list (in word) of about 500 items. This list changes weekly and change have to input manually. This list then gets copied and pasted into over 40 different documents. Is there a feature within word or Office that would allow her to add some sort of dynamic list or something?
thanks,
thanks,
ASKER
its basically just a list of current clients that my user needs to put at the end of every bid they give. The list is three columns wide and goes for about 3 pages. It's formatted all nice with headings and stuff for the bid.
You could run a macro that can copy data from the source into Microsoft Word. I did something like that for PowerPoint.
You could keep it in a separate Word document and insert it into each document as needed:
Insert tab, Text group, Object button dropdown and then 'Text from File...' item
Insert tab, Text group, Object button dropdown and then 'Text from File...' item
When you say 'dynamic', do you mean that you want exiting documents to show the latest list?
ASKER
yes that would be idea. I just want to avoid having to cut and paste into each of the 40 bid templates.
ASKER
aj7159, do you have a link or something that might get me started. I've never written a macro before.
It wouldn't update, but you could select the text and choose: 'Save selection to the Quick Part Gallery' in the Quick Parts dropdown. You insert it in documents later via the same button.
Would there be anyway you can have the data file in Excel? You can use links when paste data over from the Excel file. You can set it to auto update. Not sure what type of list it is, but I am sure you can port it to Excel.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What kind of data is it? how dynamic you want it to be. plz be little specific.