Brief background:
I'm creating a "calculator" to reduce the time it takes to format a file for my job. The file has to be formatted very specifically as it is fed into our system. The idea is that I paste raw data into "sheet2" of the workbook and the file creates itself perfectly. All i have to do is save the file in the correct format.
The first column of my file uses the following formula to add record indicator to each row that is populated with a value in the B column, else the cell is left blank:
Column two cells are populated using this formula, which looks at sheet2 (in which I copy/paste the raw data for the file) and if a value exists in the target cell, the value is added to the calculator sheet:Please Login or Register to view this content.
Subsequent columns use similar formulas, each based of whether or not the relevant cell in column B contains a value.Please Login or Register to view this content.
MY QUESTION:
Because the file format used is tab delimited, if I just extend the formulas used down the columns for a few thousand rows to guarantee all the records are created, the tab delimited file saves a whole bunch of blank rows which will cause errors in the system.
Therefore, is there a way that I can make my formulas automatically add themselves to the next row, IF the current row is populated with values?
Bookmarks