Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accouting & Database
Hi Currently I have an" Expenses worksheet" and "Project Expenses Worksheet". The Expenses Worksheet is my company monthly expenses and project cost paid out and the Project expenses is the profit and loss sort out according to the project names. Both Worksheet are rather similar. Column A is Date, Column B is Cheque No., Column C is Paid to/ Recieve from, Column D is Payment for/ for..., Column E is Amount Debit and Column F is amount Credit. I realise i have been doing double job, and am actually wasting alot of time by keying almost the same thing in two worksheet. Can some experts advise me what to do? And Column C is actually my list of suppilers name. Is there anyway to do a database for Column C, something like pick from list, but the list is another worksheet of my suppiler database. I can email you my worksheet for a clearer idea. Mindy Ong -- Mindee ------------------------------------------------------------------------ Mindee's Profile: http://www.excelforum.com/member.php...fo&userid=6799 View this thread: http://www.excelforum.com/showthread...hreadid=268410 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |