ianlee1
asked on
Auto increment macro code
Hi,
Thanks to experts exchange I now have a macro that adds a new row to the bottom of a worksheet. What I now want the macro to do is to look at the value in a cell above (e.g Say cell A15 contains the value "20"), increment this by 1 and populate cell A16 in the new row with the value 21.
Hope this makes sense.
Ian
Thanks to experts exchange I now have a macro that adds a new row to the bottom of a worksheet. What I now want the macro to do is to look at the value in a cell above (e.g Say cell A15 contains the value "20"), increment this by 1 and populate cell A16 in the new row with the value 21.
Hope this makes sense.
Ian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.