formatting error

So I'm pretty sure this is a simple fix but it has got me stumped. I have a data table for which I am trying to run conditional formatting for a whole row when particular criteria is met in the last few columns of the table, however the formatting is only affecting column A. I am using the...

Trying to complete a macro to pull data from one worksheet to update erroneous data on another. There are three columns to work with, and for the first two columns, the code works just fine. For the final column, the macro cycles through the first If statement with no trouble, but returns the...

Hi, I have a form I created for my office that uses Excel 2007. To create a unique ID for each form completed I created a formula that takes the name entered in one cell and concatenates it with the date & time in the adjacent cell. The date and time is calculated using the NOW() function in...

Hi, thanks for reading. I'm editing several supplied spreadsheets which have been compiled from many horrible locations. There is a format diffefence in the main sheet (i cant clear it with Shift Ctrl * or format paste) It is causing my pivot table to return multiple values for the same item...

Hi All, this one is really doing my nut in. I have a brief piece of code to loop though a folder of workbooks and copy each sheet into a new workbook, consolidating them. I apply no formatting or anything, just like a straight right click > move/Copy. But when I copy with worksheet, certain...