Search results

I have tried changing the order. I have commented out those routines. I have done all kinds of things. I can do this in any order manually. When I run the script, I have the issues. The order is different in the script above because I was changing it around to see if it helped the issue. I...

Sub cmdButton6_OnClick() Two Three One End Sub Sub One() Range("Table1[Cumulative % Complete]").Copy Range("Table1[Actual % Complete]").PasteSpecial Paste:=xlPasteValues End Sub Sub Two() Range("Table1[Revenue Realized]").Copy Range("Table1[Realized Revenue]").PasteSpecial...

None of them are overlapping. The strange thing is that I can manually copy and paste each of these ranges without a problem. It is only when I run the script with all three that there is an issue. I spent a few hours last night trying to figure this one out and it has me completely stumped!

This is still doing the same behaviour. The copy and paste from "Revenue Realized" to "Realized Revenue" deletes the the data out of Revenue Realized and does not update Realized Revenue. If I comment out the other copy and pastes, this works fine. If the other copy and pastes are not...

I have a spreadsheet that must have values from three seperate columns copied and pasted into three other columns. The columns being copied from have their data generated from formulas. I need to paste the values only into the new columns. The original values and formulas must be left in the...

I need to change the color text of Cell B2 if any value in table column K, meets the a condition. I am using the following formula, but missing something because I get an error. Any help would be greatly appreciated. ND(Table1[Cumulative % Complete]<1,AND(MONTH(Table1[Est Month...

Great! I see what the issue was now.

I am trying to create a conditional formatting formula that will highlight a cell when the month and year for the date listed in is less than or equal to the current month and year. Cell A2 = Today() Table column I4 to I16 = any entered date I want to ignore the days and only focus on the...