Macro insert data, need to insert rows

B

Brad

I have a macro that imports data from a CSV text file. Currently, it only inserts about 30 rows and 6 columns. Four of those columns have numbers that get totalled at the end of the import. My totals line is at line 45 (the import starts at row 6). The problem is that if more rows are added, and the data import goes past row 45, it moves my totals line over to column G (column 7) and nothing gets tallied correctly

How can I make it so that, when the macro runs, instead of overwriting or moving my totals line it just adds a row above the totals line? I want it so that if the data goes to row 49, the totals line "moves" to row 51 ( I need one row blank betwen the end of the data and the totals line)

Thanks.
 
F

Frank Kabel

Hi
you may post your existing macro for adapting :)

--
Regards
Frank Kabel
Frankfurt, Germany

Brad said:
I have a macro that imports data from a CSV text file. Currently, it
Click to expand...
only inserts about 30 rows and 6 columns. Four of those columns have
numbers that get totalled at the end of the import. My totals line is
at line 45 (the import starts at row 6). The problem is that if more
rows are added, and the data import goes past row 45, it moves my
totals line over to column G (column 7) and nothing gets tallied
correctly.
How can I make it so that, when the macro runs, instead of
Click to expand...
overwriting or moving my totals line it just adds a row above the
totals line? I want it so that if the data goes to row 49, the totals
line "moves" to row 51 ( I need one row blank betwen the end of the
data and the totals line).
 
Top