How to input/output from/to a single cell in excel?

[kent christensen]

Okay so i have an excel spreadsheet that has some customer populated cells. The customer answers are:
Customer name in cell B4
Contact Name in cell F4
Phone number in cell F5
Acct. Manager in cell B13
Products in column H
Qty in column I


I have a blank space in the spreadsheet in cells G18 and G19

I would like the date to go in G18 and a currency value to go into G19

I have a query that will take the items in column H and based on qty of column I, it will provide the currency value to go into cell G19.


I have a table called "quote" that has the following fields :
quote id (set up as an auto number),custome r name, contact name, phone number, acct. manager, date,and total price(the currency value)


So what i want is to use this sheet to input the data into access, store all the info in the "quote" table(dont care about storing the data in column H and I) Then run the query using the data in columns H and I, get that total price from that query and also store it into the "quote" table.

Then once this quote table is populated, output the data into a copy of the same spreadsheet using the same format.

Is this possible? Sorry if this is a little confusing. I can send over my database and spreadsheet if someone could do this for me.

Thanks in advance.

[dsatino]

Yes, it's possible. You'll need to use VBA and the methods associated with Excel. I've not used them often so I don't want to write you any code specifically.

You might want to just google MS Excel VBA. You should get some pretty good results on how to navigate around the sheet.

[kent christensen]

I tried to google it but i could not get it to work. If anyone is willing to help me do this i could send over the excel file and database and give you better instructions. It would be greatly appreciated.