Need help in vba to make a packing list

[mehidy1437]

Hi guys, I want to DIVIDE each cell in a selected range, for this case its B2:E4 by 30 & put the divided result in column F, the balance after divide will show on the below cell.
This will continue for the rest of the cell & row.

is it possible to do in VBA?

Here below the image for your ref.

FROM THIS
fthis.JPG

TO THIS
tthis.JPG

[Pete_UK]

Virtually everyone who posts here needs help, so your title is not very useful - it should reflect what you are trying to achieve. I suggest you change it before a moderator comes along and forces you to do so. See the Forum Rules at the top of the screen.

Pete

[mehidy1437]

Virtually everyone who posts here needs help, so your title is not very useful - it should reflect what you are trying to achieve. I suggest you change it before a moderator comes along and forces you to do so. See the Forum Rules at the top of the screen.

Pete

Thanks, hope its okay now.

[Akuini]

Try this:
I put the result in column J:P.

Please Login or Register  to view this content.

[mehidy1437]

Many thanks, i'm checking and working on it. Will get back with the feedback.