Dear all,
In the sheet1 of the attached file, I want to replace column A with the corresponding value of non#NA cells of column B with its respective value in column C.
The result must be something in sheet2.
I will appreciate any guide in advance.
Nazanin
I am havuing a hard tuime understand what you are doing here
If you are looking to physically replace specific cell contents in column A with anything else, a formula wont do that for you anyway. Formulas only affect the cell they are in, not other cells
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks