Please could someone help,
I have conditionally formatted a range of cells in a column based on another column to highlight duplicates.
I would now like to copy all of the highlighted values to another column in the same row - can this be done by VBA or using a formula to determine acknowledge the CF and copy/paste the cell value not the fomula?
Thanks in advance!!
Fast Answer..................No, Excel and VBA know nothing about the conditional format of any cell.
The good news is that you have your conditional formulas, so you can use them to drive your Macro or your formula.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you very much for replying so quickly, it is quite urgent!!
Please see the test workbook enclosed, I hope this clarifies my question, if you require any further info let me know.
Liam
If you want the value (not formula which gives you the value) you will need VBA:
=IFERROR(IF(MATCH($C2,$I$3:$I$24,0),$C2,""),"")
Above is the formula required in G2 and copy down
Hi I put the formula in G2 and nothing happened, the cells are still blank?
Liam
Right Click on your sheet name at the bottom of excel and select view code.
Paste this code in the window that opens and close it.
select another sheet on the spreadsheet and then select your spreadsheet, this will run a macro to fill all rows in column g.
changing cells in column C or column I will also run the macro.
'************************************************************************************
NB Your Spreadsheet is set to manual calculate so Johns formula does not work automatically.
'************************************************************************************
Please Login or Register to view this content.
Liam: Have you tried applying a filter by color to the column?
Apply the filter using the CF color you want to copy. Highlight the cells you want to copy. F5 (go to). Special. Visible cells only. Copy. You can open a new sheet if you like. . (CTRL + N). Paste special. Values.
Pete
Did you ..??
Above is the formula required in G2 and copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks