Paul, thanks for taking a look. I start by copying the contents of the MASTER SAVE tab and paste values into Cell A1 of Worksheet tab. I then run the macro NCFL_cleanup to get rid of everything on that page except the single column of data I want to use. The idea is then to paste the column of data into Column F of the SCRAP tab. In there I already have Cond Formatting underneath, and some formulas to the right of that data.
I see what you mean by text versus numbers etc. One issue I have is that some of the data I want to paste in is percentages and others are whole numbers. On Tuesday, April 12, 2016 at 1:39:51 PM UTC-4, Paul Schreiner wrote: > Can you attach an example? > It's difficult to guess what MIGHT be happening based on your description. > > When you "copy" the data into the cells, are you pasting the entire > contents or have you tried to "Paste Special -> Values" > ? > > Are the values numeric or alpha-numeric? > > It's possible when you copy and paste the cells, you're getting "text" > pasted into the cells. > But when you re-type the value, Excel re-interprets the value and changes > the cell content type. > > For instance, if your conditional formatting tests the value for >1 > and you copy/paste a value that is "2", > well, a TEXT value of "2" is not greater than a NUMERIC value of 1, so the > condition is false. > but, if you TYPE a 2, then Excel recognizes that 2 > 1 and the condition > is true. > > *Paul* > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > > On Tuesday, April 12, 2016 1:23 PM, Johnny <fle...@gmail.com <javascript:>> > wrote: > > > > Hi All, I searched for an answer on this first but I'm hoping for some > easy, good advice. > > Using VBA, I have preloaded some cells with formula-based conditional > formatting. When I copy a column of data into these cells, the conditional > formatting does not take effect. > Also, formulas in neighboring cells to the right do not change based upon > this copied-in data. If I go to one of these copied-in cells and just > re-type the data, the Conditional Formatting and neighboring formulas work > as written. > > I tried Data->Refresh All, and that didn't seem to work. Thanks for any > advice on this (hopefully easy) issue. -- John > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com <javascript:>. > To post to this group, send email to excel-...@googlegroups.com > <javascript:>. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
NCFL KMI Automation.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
