uuffff ! what an if !

  • Thread starter Thread starter gaftalik
  • Start date Start date
G

gaftalik

Hi everybody !

In a sheet named "Journal" i have many column
(Date,Desc,Debit,Credit)
If i wrote under Date (ex:A2)=>Feb22
under Desc (ex: B2)=> payment to john salary
under Debit(ex: C2)=> 20 $
and in A3 Feb22
B3 Loan to Tom
C3 5$

Assuming "john" & "tom" each has a sheet with columns Date;Desc,Debi
,is there any formulas to be under each of the columns so that eac
time the word "john" or "tom" under column 'Desc' in sheet "Journal
appears , the Date , Desc, and the Debit records will mov
automatically accordingly to each's sheet , in order not to copy in th
end of the day the records of john , tom or whoever separately to thei
sheets ?

I appreciate any one's help , thank you
 
Yes, this can be done automatically. But something has to happen to trigger
Excel to do this. For instance, an entry in the Desc column can trigger
this to happen. But then all the other columns need to be filled in before
the Desc column. The same if you choose any other column as the trigger.
Is this what you want?
Or maybe, at the end of the day, you can click on a button and all the
entries will be moved to their respective sheets. Post back and tell us
how/when you want this to happen. HTH Otto
 
Hi ,
Thanks for your support.
Am i supposed to do this at a click in the end of the day or each tim
i am typing a transaction it will be copied automatically based on
formula approach in the person's sheet which will look a kind of :
=if(isnumber(find("tom";(range)));lookup or return the cell address
that's what i was trying to figure , but since many entries for tom o
john could be made so , so far i couldnt manage :rolleyes:
The macro buttom could be a solution too if this formula approach i
not possible

Thank you again
 
What I am saying is that you can do this with VBA (programming). The
process is: (at the end of the day)
You click on the button
The code (macro) scans each row in the pertinent column or columns and looks
for whatever (John, etc).
If it finds it, it copies the entire row and puts it in whatever sheet you
want (if John has a sheet named John, it will go there.).
No formulas.
If you want to do this after you complete each row, then the code can be
written to work on the active row only. HTH Otto
 
Back
Top