Is there a simple macro to copy a number from one column, round it to 0 decimal places and place in another column but not the same rows down?

[yblcolin]

Is there a simple macro to copy a number from one column, round it to 0 decimal places and place in another column but not the same rows down?

								​
				3352.76

 

[igold]

Hi yblcolin- welcome to the MrExcel Board. Yes, with a couple of clarification questions, this would appear to be a straightforward simple code.

That said, due to it's apparent simplicity, you may be better served, if you used the Excel built-in Macro recorder to see how it can be done. If you don't know how to use it, a simple search will yield plenty of instructions.

 

[yblcolin]

As I'm old, I used to use Lotus 123 and setting up macros in that was very easy. I have tried recording macros but never had any success, probably because I'm IT stupid. The stumbling block seems to be the lack of an 'End' function in Excel macros.

 

[MARK858]

Seeing as I can't tell by your image exactly what the cell references are, the macro below takes the value in E5 and rounds it to zero decimal places in I1, is that what you want... if not then I need more info

Book1.xlsb
	E	F	G	H	I
1					3353
2
3
4
5	3352.76
6
Sheet3

Sub RoundOffset()
Range("E5").Offset(-4, 4).Value = Round(Range("E5").Value, 0)
End Sub

 

[igold]

Assuming @MARK858 cell references are correct, and this is the only thing you want to accomplish, why not just do it with a formula...

Book1
	A	B	C	D	E	F	G	H	I	J
1		1609.18			1609.18	gf		MD-60 V2, 1.2mm gauge decking, 150mm deep	3353	m2
2		1267.12			1267.12	1f
3		476.46			476.46	2f
4					-----------
5					3352.76
Sheet1

Cell Formulas
Range	Formula
I1	I1	=ROUND(SUM(E1:E3),0)
E5	E5	=SUM(E1:E3)

 

[MARK858]

Assuming @MARK858 cell references are correct, and this is the only thing you want to accomplish, why not just do it with a formula...

Maybe because of this part of the question

Is there a simple macro to copy a number

and the way the question is worded i.e

and place in another column

seems more fitting to a vba offset rather than a formula, where you are putting the formula in a known cell rather than in relation to the original cells position

 

[igold]

Maybe because of this part of the question

Yes, I get that part (see my post #2), but the OP is not exactly forthcoming with details, hence my question... I guarantee there is more to this than what is conveyed in Post #1.

 

[MARK858]

I guarantee there is more to this than what is conveyed in Post #1.

I'm sure there is but I posted the code because the OP specifically asked for code, and with no more details (or reasons why they asked for a macro i.e. it might be part of a bigger procedure) I stuck to what the OP has asked for (I also note that you suggested using the macro recorder to get the code needed)