Adding a line over multiple sheets

[c991257]

Hi,

I have a work book for forecasting worker related costs and once in a while I need to add a worker.

The problem is that in the workbook I have to insert him in the correct department which means that he doesn't go to the end of the sheet automatically.

On the Subsheets I then need to copy a lot of formulas onto the row the new guy was inserted in, otherwise the costs of this new guy won't be forecasted. Is there a way to do this in an easier way, I.e. have excel add a line on every subsheet and basically copy the formulas from a line above or similiar?

/Møller

[Bryan Hessey]

Hi,

I have a work book for forecasting worker related costs and once in a while I need to add a worker.

The problem is that in the workbook I have to insert him in the correct department which means that he doesn't go to the end of the sheet automatically.

On the Subsheets I then need to copy a lot of formulas onto the row the new guy was inserted in, otherwise the costs of this new guy won't be forecasted. Is there a way to do this in an easier way, I.e. have excel add a line on every subsheet and basically copy the formulas from a line above or similiar?

/Møller

HI,

yes, record a macro doing what you want, then edit the macro so that it is not 'row-specific' to what you did, but locate the correct place to add.
Add also a line 'For each ws in Sheets' where ws was dim'd as Sheet etc.

hth
---