S
steverv
I have a spreadsheet that has hundreds of rows and 6 columns. Each row is a
project and can have spend in any of the 6 columns, either in single columns
or any combination. Once completed I need to add rows to each project that
has expenditure: e.g.
A B C D E F Total
project 1 £100 £50 £300 £50 £500
This project would need four rows adding below. Is there a formula or macro
that can do this? I can count the columns with data in them, but then I
cannot work out how to add the rows based on these numbers. Can anyone help?
project and can have spend in any of the 6 columns, either in single columns
or any combination. Once completed I need to add rows to each project that
has expenditure: e.g.
A B C D E F Total
project 1 £100 £50 £300 £50 £500
This project would need four rows adding below. Is there a formula or macro
that can do this? I can count the columns with data in them, but then I
cannot work out how to add the rows based on these numbers. Can anyone help?