Hi Everyone,

I don't know if it is possible to do what im hoping, but its worth asking the question.

I work with accounts and apply for values of projects based on percentage complete, it would be laid out similar to below

HEADER WORK TITLE VALUE PERCENTAGE SPLIT PERCENTAGE VALUE
CONTRACTED WORKS 1920: INSTALL FANS £10000
CONTRACTED WORKS 1930: ISTALL LIGHTS £20000

What I would like to do in VBA is that we sometimes have to split it into percentages, this could be in 10% increments, 20%, 25%, 50% or 100% dependant on the client

If in percentage split we selected on a data validation 20% on install fans, then I would like 5 blank lines inserted underneath with each value being split into 20% increments, so £2000 each one, if they decide to change this to 10% increments, then this should adapt it to 10 cells inserted in total and each value to be £1000, if they adapted it to 50% increments then it should be just to blank cells each worth £5000

It would have to be a pretty clever code as you may have to insert cells if the percentage is reduced, but if the percentage is higher, then it would have to delete cells.

I do hope that make sense, and would really appreciate any help.

Kind regards,

Simon.