What function(s) are best to use and when?
 

I have a general ledger that I am trying to create. I need to know what
function do I use to automatic post items from the general ledger to their
sub accounts
--
Sir McMillan

What function(s) are best to use and when?
 

Check out Help on "linking cells"

Assume two sheets.

On sheet2 in a cell enter =sheet1!A1

The contents of sheet1 A1 will show up in the cell in sheet2.


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 10:12:02 -0700, McMillanY45
wrote:

I have a general ledger that I am trying to create. I need to know what
function do I use to automatic post items from the general ledger to their
sub accounts

What function(s) are best to use and when?
 

Can I try to set up what I want the spreadsheet to do? There will be
worksheets numbered 1-5. I will enter all information on worksheet one. There
will be a column(F) that will specify worksheets 2-5 per row on worksheet 1.
According to what numberis entered in column(F) on worksheet one, I need for
all of the information on that row to transfer to that specific spreadsheet.

Example:
Worksheet 1
A B C D E F G
9 28 loan clothes 3 $20.00

Worksheet 3
A B C D E F G
9 28 loan clothes 3 $20.00

Because of Column F and the number 3 all of the information on that row went
to worksheet #3.

I have tried out a thousand IF functions, but nothing seems to work. I have
figured out how to get them to the specific sheets but the are empty rows if
the number does not pretain to that worksheet. I need to be able to skip a
row if it doesn't pretain to the worksheet. Let me know what you think.
--
Sir McMillan


"Gord Dibben" wrote:

Check out Help on "linking cells"

Assume two sheets.

On sheet2 in a cell enter =sheet1!A1

The contents of sheet1 A1 will show up in the cell in sheet2.


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 10:12:02 -0700, McMillanY45
wrote:

I have a general ledger that I am trying to create. I need to know what
function do I use to automatic post items from the general ledger to their
sub accounts

What function(s) are best to use and when?
 

For transferring data values from one sheet to another I'm thinking that VBA
would be your best bet.

I don't understand the part about "empty rows if the number does not pertain the
that worksheet"

Based on the number in column F, that row would be copied to the pertinent
worksheet to the next available row below the last copied row.

I will try to work something up but can take a while.

In the meantime see how Ron de Bruin copies data using VBA.

http://www.rondebruin.nl/copy1.htm

Could be you can adapt one of his routines.


Gord Dibben MS Excel MVP


On Thu, 28 Sep 2006 12:18:01 -0700, McMillanY45
wrote:

Can I try to set up what I want the spreadsheet to do? There will be
worksheets numbered 1-5. I will enter all information on worksheet one. There
will be a column(F) that will specify worksheets 2-5 per row on worksheet 1.
According to what numberis entered in column(F) on worksheet one, I need for
all of the information on that row to transfer to that specific spreadsheet.

Example:
Worksheet 1
A B C D E F G
9 28 loan clothes 3 $20.00

Worksheet 3
A B C D E F G
9 28 loan clothes 3 $20.00

Because of Column F and the number 3 all of the information on that row went
to worksheet #3.

I have tried out a thousand IF functions, but nothing seems to work. I have
figured out how to get them to the specific sheets but the are empty rows if
the number does not pretain to that worksheet. I need to be able to skip a
row if it doesn't pretain to the worksheet. Let me know what you think.