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

M

McMillanY45

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
 
G

Gord Dibben

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
 
M

McMillanY45

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.
 
G

Gord Dibben

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
 
Top