LinkBack URL
About LinkBacks
copy sheet 2 cell f1 if it contains text if not copy c1 form sheet 2 to sheet 1 cell a1
copy sheet 2 cell f1 if it contains text if not copy c1 form sheet 2 to sheet 1 cell a1
I think you need to give a bit more detail on this. You know what you want, we dont
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
just my two cents worth, (may not be worth more than that) but is this what you want? =IF(Sheet2!F1<>"",Sheet2!F1,Sheet2!C1)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
i have a list of vendors in column c and a list of company names in column f most of the time these match but some of the cells in column f are blank. i would like to look at column f if blank use whats in column c but if not column f takes precedent. then i would like to send that into to a different sheet.
hope this helps
this is my first post so if i need to get more technical please tell me how.
thanks for your interest.
My formula should work for you then.
Thanks everyone your right it did work.
thanks again
Thanks everyone your right it did work.
thanks again
how do i close this thread.
Use the thread tools drop down at the top of the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks