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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accouting & Database
hi,
are the expences and project expences in the same workbook? If they are, then you might make use of formulas to draw same entries from one sheet to the other for example: expences are one sheet1 and project expences are on sheet2' on sheet2 enter the formula =sheet1!A1 what ever you entered on sheet 1 cell A1 will appear on sheet2 in the cell you put the fomrula in. hope it helps :) -----Original Message----- 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? action=getinfo&userid=6799 View this thread: http://www.excelforum.com/showthread...hreadid=268410 . |
Reply |
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) |