I am trying to automatically copy cells from Sheet 1 to Sheet 2. I have gotten this to work partially for one column (column A = "KERX"), but when I try to use this same formula for returning the value of SRPT (column A = "SRPT"), this does not work.
I have included a sample file to explain this better.
Book1.xlsx
Last edited by SamuraiSam83; 01-08-2015 at 07:48 PM. Reason: I just found out that I can upload an Excel file
Try this, it worked when I tested it .... paste this in cell C10 =IF(Sheet1!A12="SRPT",Sheet1!C12,"") then copy it to the other needed cells in that column
Last edited by gmr4evr1; 01-11-2015 at 07:57 PM. Reason: Added uptaded file
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi gmr4evr1, thanks for the help. I think this will work for what I am trying to do!
No problem, glad I was able to help you out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks