Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a database?
Hi
im a builder and i use word with an excel insert to create my invoices. The excel sheet is added over the top of my letter and is used for itemising the bill. For example it would list materials, days of labour, plant hire etc. and the relevant prices, with a total at the bottom. Quite straightforward. At the moment when im working in excel, creating the invoice, i just insert the materials and prices as im going along, every time typing in an item, checking what the correct price is, typing it in and working down the list. What i would like to do is build up a database of materials/items and their respective unit prices. Then every time i do an invoice i could import this data across with a single click!! Ive had access mentioned to me and ive tried to find a simple solution with the aid of help files etc...but it all seems so complicated!! Could anyone point me in the right direction!!! any help greatly appreciated.......Tony |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a database?
You don't need access.
Find three columns on the right of your worksheet, Put in code, descriptions, price, in your usual place for material, you put in vlookup(code, range, 2), likewise for price, vlookup(code, range,3) "tony" wrote in message ... Hi im a builder and i use word with an excel insert to create my invoices. The excel sheet is added over the top of my letter and is used for itemising the bill. For example it would list materials, days of labour, plant hire etc. and the relevant prices, with a total at the bottom. Quite straightforward. At the moment when im working in excel, creating the invoice, i just insert the materials and prices as im going along, every time typing in an item, checking what the correct price is, typing it in and working down the list. What i would like to do is build up a database of materials/items and their respective unit prices. Then every time i do an invoice i could import this data across with a single click!! Ive had access mentioned to me and ive tried to find a simple solution with the aid of help files etc...but it all seems so complicated!! Could anyone point me in the right direction!!! any help greatly appreciated.......Tony |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a database?
Hi
so your saying on my default workspace that i use for the invoice, i save all the materials and their prices somewhere to the right of the worksheet and then when filling in my invoice i put in 'vlookup' and it will give me a selection of all the items ive listed on the right of the sheet? sorry if i sound dumb but im a very basic user of excel. "vlookup(code, range, 2)" all sounds new to me but im sure i can track it down and get my head round it if im understanding you correctly!!!! Thanks Tony "PY & Associates" wrote: You don't need access. Find three columns on the right of your worksheet, Put in code, descriptions, price, in your usual place for material, you put in vlookup(code, range, 2), likewise for price, vlookup(code, range,3) "tony" wrote in message ... Hi im a builder and i use word with an excel insert to create my invoices. The excel sheet is added over the top of my letter and is used for itemising the bill. For example it would list materials, days of labour, plant hire etc. and the relevant prices, with a total at the bottom. Quite straightforward. At the moment when im working in excel, creating the invoice, i just insert the materials and prices as im going along, every time typing in an item, checking what the correct price is, typing it in and working down the list. What i would like to do is build up a database of materials/items and their respective unit prices. Then every time i do an invoice i could import this data across with a single click!! Ive had access mentioned to me and ive tried to find a simple solution with the aid of help files etc...but it all seems so complicated!! Could anyone point me in the right direction!!! any help greatly appreciated.......Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
Problem importing data into sql server database | Excel Discussion (Misc queries) | |||
Importing from access database into multiple spreadsheets | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
.csv file creation for importing into a database | Setting up and Configuration of Excel |