Hey,
I have a table of data, a lot of which have formulas. Ideally what I am looking to do is if Cell B12 is populated, then in c13, the formula form c12, d12, e12, f12, g12, h12, i12, k12, and so on. Essentially any cell directly above it should be copied down once cell b12 is populated. This will then again happen when cell b13 is populate.
I would suggest adding this to your formulas in columns C:K
=If(b12="","",xxxxx) Where XXXXX is your original formula.
Then drag the formulas down as far as you would like. This way the row appears blank until b12 is populated, and then the formula calculations will automatically be displayed.
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks