duplicate formula cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Right I'll try and ask this as clearly as i can...
I have a worksheet where I have to work out what size pipe i need for a
specific room, so i have a selection of cells with formulas in it. I want to
keep one set of these cells on the worksheet but have the ablity to click a
button that will replicate all these cells to the lines below for another
room, and so on and so on. so for e.g. have the ability to click a button
that will replicate the follwing cells (2R x 8C) C14 to J15, (all included).
with a button - to a line below, with the ability to do this over and over.
But i want to insert them as rows so that if there was any text below it it
wouldnt overwrite it, please please help!
 
I don't know about clicking a "button" to get this done, but this is how I
handle it in my spread sheets.
Using your mouse, highlight the cells you want and click copy.
Then RIGHT click on the first cell you want the formula row to copy to;
select paste special, select foumulas, ok.
This will copy only your formulas into the rows and cells you've selected
leaving you ready to fill in the next set of information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top