header2

Hello all, I am working on a project and I have come to a problem I don't know how to solve, I have a grid of Data, Row Descriptions (Column B), and then My headers in columns "H:AP" and then the corresponding rows in between Range("H9:AP128"). So, I need code or even a formula that will go...

Hi All, I need macro for the below task. I need to copy each set of data under each header from column B to column D, column E, and so on. <colgroup><col span="2"></colgroup><tbody> Column A Column B Server1 Header1 Header2 Date1 Value1 Date2 Value2 Date3 Value3 Date4 Value4...

Hello Everyone, I have a query in VBA multiple if conditions. if you are writing vba code for sum and if any of the column have 0 then it will throw an error. So, What i am tring to do is writing a vba code where any of the columns have "0" value then it should give "0" in the sum column. and...

List header columns. In Sheet 1 there are 3 columns (say C, D and E). In each row, starting with row 2, there are 3 items, usually identical. What formula should be used, so if the 3 items in a row are the same then the formula returns "YES". If one of the cells is a different item, then list...

Hey, I have a data source of numbers from AS400 that I need to paste into Excel, I usually manually type the zero after the left cell but wanted to see if possible to paste in leading zero's which it was if you format as text. However this now pastes the whole data source into one column and...