Hi!
Have been stalking this forum for a loooong time, but have found something that I cannot find an answer for. Currently doing a student placement at an engineering firm and I am trying to build improve one of the Civil Engineers excel built calculation tools that lets you enter drainage information (cover levels, pipe sizes, invert levels etc) and then spits out a ready made manhole schedule that you can simply copy and paste into our CAD program for issue.
Now, as it stands, it current requires you to edit the into on one sheet, then another, then another. I've already managed to shorten some of this down, but one of the annoying problems I have is that as I am using 4/5 different sheets, even if its now mostly automated (input on sheet 1 for out puts on all the others), when I need to enter a new row, I have to do it for all 5 sheets. Then drag the formula down. Then reformat it with borders, colors, text and the like. A pain and for big jobs can take a good while.
What I am thinking is to have a button on the 1st sheet that is attached to a macro that then copies and pastes the formula in the top row "N" times into each of the sheets, where N is a number next to the button. How can I do this so that its A) Basic (as I have extremely limited visual basic skills for the macro editor) and B) That does that dragging formula down does. I cant have it just copy and pasting the formula as everything will have the same result. If I drag it down from A1 to A10, the formula in each cell needs to know this (if you get what I mean).
Thanks a lot,
Grady
Bookmarks