|
|
#1
04-21-2014, 11:11 AM
|
|||
|
|||
Macro to copy formula from one cell to another
Hi Experts,
I've data in two columns, 'Column A & B'. 'Column A' contains formula and 'Column B' contains criteria. I need to find the output like that cell from 'Column A' will automatically be copied and pasted as value into 'Column C' whenever specific criteria meet in 'Column B'. Column A Column B 1. 100 ...... D 2. 300 .......R 3. 500 .......D 4. 100 .......R 5. 300 .......D Now I need to copy cell from Column A that meet the criteria in Column B. logical function will be like that "=IF(B1="R", then copy A1 and paste value into C1)". Please provide excel macro VB coding for getting the desired solution. Many Thanks, Anwar Dhaka, Bangladesh. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
|
Use formula to copy cell formats also
|
mike_abc | Excel | 10 | 12-10-2011 01:55 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
