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

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

.