Srecruiter Posted November 24, 2014 Report Posted November 24, 2014 evaraina unnara.. I need to write a query to compare the array values with the column headers. The excel sheet is placed in some folder x in C drive. If the workbook headers doesn't have any value specified in the array then it should write the value as column header and write zero's in it. Example: Array has column1 to 4 but my excel header has only column1 and column2(has data in it)..so the expected output should be column1 |column2|column3|column4 with column3 & 4 zero's in it. please evaraina help cheyandi..urgent issue :(
Spartan Posted November 24, 2014 Report Posted November 24, 2014 http://www.thespreadsheetguru.com/the-code-vault/2014/7/21/selecting-non-blank-cells
DaleSteyn1 Posted November 24, 2014 Report Posted November 24, 2014 youtube lo videos unnay ilanti scenarios ki choosi raaseyadame .
DaleSteyn1 Posted November 24, 2014 Report Posted November 24, 2014 record a macro in your excel sheet vba script generate aipodhi automaticga .a script lo changes chesko
Recommended Posts