Combining two columns and retuning the result in a third

[gberg]

I have two tables (they will have the same number of rows) on two different worksheets.
Table 1 on Sheet 1 has columns for Feet and Inches
Table 2 on Sheet 2 has a column for Length

Is there a way to:

• Divide the Inches column by 12 to get it into feet, then combine it with the feet column
• Paste the result into the Table 2 "Length" column on Sheet 2

Example:
Table 1 (on Sheet 1)

FEET	INCHES
10	6
5	3
8	0

The end result would be
Table 2 (on Sheet 2)

LENGTH

10.5

5.25

8

Thanks

Greg

 

[Peter_SSs]

Is this what you mean?

gberg.xlsm
	A	B
1	FEET	INCHES
2	10	6
3	5	3
4	8	0
Sheet1

gberg.xlsm
	A
1	Length
2	10.5
3	5.25
4	8
Sheet2

Cell Formulas
Range	Formula
A2:A4	A2	=Sheet1!A2:A4+Sheet1!B2:B4/12
Dynamic array formulas.

 

[gberg]

Sorry, I wanted to do this in a VBA code

 

[gberg]

I just tried your formula and it works!

=Table1[@Feet]+(Table1[@Inches]/12)

I then just copy the formula down, all good!

Thanks for your help

 

[Peter_SSs]

Sorry, I wanted to do this in a VBA code

Like this then?

Sub ConvertLength()
  Dim lr As Long
  
  lr = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
  With Sheets("Sheet2").Range("A2")
    .Formula2 = Replace("=Sheet1!A2:A#+Sheet1!B2:B#/12", "#", lr)
    .SpillingToRange.Value = .SpillingToRange.Value
  End With
End Sub

 

[Peter_SSs]

=Table1[@Feet]+(Table1[@Inches]/12)

I then just copy the formula down, all good!

If they are both already formal tables with the same number of rows then you should not need to copy the formula down, it should automatically spill down

 

[gberg]

Peter, thanks for the help I got your solution to work!

 

[Peter_SSs]

Cheers. Thanks for letting us know.