Expand and remove parts of worksheet

[Beeps]

Hello!

I'm an servicetechnician for a company in Norway, where we maintain and repair industrial machines (CNC).
From time to time we have to check the geometry of the machines. This is done by using lasers, levels and etc.

When using a level to check the machine, we plot this in to a sheet, where some formulas calculate different values and so on.
The "problem" we have, is that no machine is alike, and we have to manually change the sheet everytime; Expanding the rows by copy-pasting, checking all formulas if they are correct and so on.
So I was wondering if someone here was able to help me with this, as I have very little experience in this.

Workbook is attached.

Here is what I'm looking at doing:

#1 (sheet 2 [Z1-Langs tabell]):
When changing the value in E3 (Number of measuringpoints), I want the columns to expand or decrease.
Originally it is set to 10. So if I want 20 points, I want it to expand to 20 rows without the need of changing all the formulas.
(Note that Row 10 and 11 has either no formulas or a different formula than the others).

#2 (sheet 2 [Z1-Langs tabell]):
When changing the value in C3 (Measuring distance), i want the numbers in column B to change accordingly.

#3 (sheet 3 [Z1-Tverstabell]):
I also want the above changes to work with sheet 3.

#4
When and if this is possible, will the diagrams in sheet #1 and #4 update themself?
If not, how can you do this?


I hope there's someone that might be able to help me, so mine and the others at my firm gets a bit easier workday!

Best regards
Eirik Bjerkgaard / Beeps

[Ed_Collins]

Please confirm... is the formula in Cell e17 on the Z1-Langs Tabell correct?

=D17/(1000/B11)

all of the cells above it and below it, are dividing 1000 by cell c3, not cell b11.

[Ed_Collins]

Nevermind...

As I understand your worksheet, c3 and b11 will always be the same number... so it makes no difference.

(Still, it's interesting how that one cell is different from the rest.)


Still working...

[Ed_Collins]

Before I go any further, please confirm this is the desired result for Request #1.

Vatring - modified with macro button.xlsm

[Beeps]

Hi!

This looks perfect! Exactly as I wanted it!

[Beeps]

Nevermind...

As I understand your worksheet, c3 and b11 will always be the same number... so it makes no difference.

(Still, it's interesting how that one cell is different from the rest.)


Still working...

Did not actually know this! It's as you say; quite interesting!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[Beeps]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Hi!

Thanks for the hints and tips. I will try and follow these as best as I can.

Unfortunatly, only one of my 3 points in this case is "solved".

And thanks again, for the info on the "thank-you-star"!

[Beeps]

Hi again!

I've updated the worksheet, with macros working on both sheets.

But I can't get the diagrams to update accordingly.
When going from, lets say 10 to 20 rows, the diagram will only use the two top lines that doesn't change.

How can I work around this?