I have a spreadsheet that has a list of names, dates and numbers. I need to find a way to copy a name from the name field and paste it into another field only if the numbers field is populated. I am not sure if this could be done using an If Then Else formula or not.
I would appreciate any help.
KS
Welcome to the Forum!
Do you really mean "copy and paste"? Or do you mean "reference"? Copy and paste needs a macro. But maybe you mean something like this. Suppose the names are in column A, dates in B, numbers in C. You would use this formula to refer to the name in row 2:
=IF(C2="","",A2)
If that doesn't answer your question then I would recommend attaching a sample workbook.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks