C
cadman
I need a time log each day that i work that will link to invoices. for
example, say i've worked 3 hours on account "A" and 4 hours on account "B"
today. How can i pull data from specific columns in a particular row. Is
there a way that on sheet 2 labeled account "A" Invoice that it will search
sheet 1 labeled Time Log for all entries for account "A" and copy the data
from an adjacent cell into the account "A" invoice? Basically, if i enter
account "A" in a cell on the time log sheet, then the hours recorded in an
adjacent cell on sheet "time log" would be duplicated into the sheet
identified as account "A".
example, say i've worked 3 hours on account "A" and 4 hours on account "B"
today. How can i pull data from specific columns in a particular row. Is
there a way that on sheet 2 labeled account "A" Invoice that it will search
sheet 1 labeled Time Log for all entries for account "A" and copy the data
from an adjacent cell into the account "A" invoice? Basically, if i enter
account "A" in a cell on the time log sheet, then the hours recorded in an
adjacent cell on sheet "time log" would be duplicated into the sheet
identified as account "A".