Hello, I'm wondering if I could put an IF statement into a macro. I want to transport data to the last available cell in a row. I can record a macro to put it into a specific cell but the action of that being the last available cell is not recognized. The next time the macro is run the cell data from the previous macro run is overwritten as only the specific cell is recognized, as I said before, and not the action of taking it to the last available cell. If I could somehow tell Excel to put it into the cell if the cell has no visible data in it (zeros are blanked out) and if the cell is full to move to the right once, all my prayers would be answered!
Is this possible???
Thanks
Is this possible???
Thanks