M
Mandi
I'm trying to transcribe information from timecards to a spreadsheet. The
person who designed the spreadsheet for me only put in equations to row 46
(not nearly enough). Heres an idea of what it looks like since I am too
uneducated on this program to know how to describe it. Cell A4 looks like
this : =IF(B3="","",B3)
A46 says, =IF(B45="","",B45). My question is: Is there a way to just
automatically put the next line's equation in, or do I have to type it all
out? Seems to me that would just double my work load. (i.e. A46 says
=IF(B45="","",B45) I want A47 to automatically say =IF(B46="","",B46)) Is
there a way to make that happen? He also set it up so that when I typed in a
date (i.e. 1/3) it would convert it into the day of the week in the next
column - is there a way to continue that on down the page? Ack!! I think
I'm even more confused now than I was 10 minutes ago. Please help. Thanks
so much in advance.
person who designed the spreadsheet for me only put in equations to row 46
(not nearly enough). Heres an idea of what it looks like since I am too
uneducated on this program to know how to describe it. Cell A4 looks like
this : =IF(B3="","",B3)
A46 says, =IF(B45="","",B45). My question is: Is there a way to just
automatically put the next line's equation in, or do I have to type it all
out? Seems to me that would just double my work load. (i.e. A46 says
=IF(B45="","",B45) I want A47 to automatically say =IF(B46="","",B46)) Is
there a way to make that happen? He also set it up so that when I typed in a
date (i.e. 1/3) it would convert it into the day of the week in the next
column - is there a way to continue that on down the page? Ack!! I think
I'm even more confused now than I was 10 minutes ago. Please help. Thanks
so much in advance.