![]() |
#1
|
|||
|
|||
![]()
I'm using MS Word 2007 to create a simple "billing statement". What I would like to do is to be able to select an "organization" name from a pull down menu, and depending on that choice, other cells in the WORD document would populate according to a database of my clients information. I'm guessing this database would come from Excel (which I could make if so). For now, I have a few "drop down lists" for certain fields, but I would prefer to have predefined cells populate according to a database. A graphical example is at http://www.shan-dysigns.com/billing.jpg
I would like the drop down menu "organization" to populate the fields with circles. |
#2
|
|||
|
|||
![]()
Hi hotlilshan, can I ask why are you using word 2007 for you invoicing? MS Word is certainly not the application for this. Either use MS Excel for a simple invoice and populate the information using vlookups or use the correct tool for the job.....Access.
|
#3
|
|||
|
|||
![]()
I'm sure MS Word isn't even close to the proper app to use for invoicing, but in the beginning, I didn't need anything extravagant. At the time, I just wanted to have something on paper to show who I billed and what I billed them. My business has grown quite a bit since then, and I've constantly battled with which way I should go in order to create a real business invoicing environment (without having to spend too much time dealing with it) - that's why I chose Word in the beginning because I don't want to take too much time outside of my actual work just to set up a billing environment. I had originally created a bill in Excel and ended up pasting it into Word, and have always stuck with Word from then on. I will try Excel again... thanks
|
#4
|
|||
|
|||
![]()
Excel will get you half way there. You should be aiming to access for the future. It's designed to work with historical data with excellent reporting and security features in a multiuser environment.
|
![]() |
Tags |
cell, data, populate, word |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kevin_ms | Excel | 4 | 09-14-2008 10:08 PM |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Nested if formulat to merge cells | cristi22 | Excel | 0 | 10-23-2006 08:28 AM |
Populate an empty .PAB file | imported_contiw | Outlook | 2 | 08-17-2006 08:50 PM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |