I will enter manual value in one row, copy and paste next row it should be increase, copy and paste previous row it should be decrease
example
copy and paste to previous row MAA256678860
I will enter one pod number MAA256678861
copy and paste to next row MAA256678862
Need vba code for that
Last edited by chandy123987; 06-19-2019 at 05:51 AM.
See in VBA inner help the AutoFill method …
You may also be able to use this in your Worksheet_Change() event:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
Removed post
Last edited by AlKey; 06-14-2019 at 08:54 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Possibly...Please Login or Register to view this content.
WideBoyDixon & Dangelor both are working well.
Small change in my requirement
A5 MAA25125680
copy and paste to some other range example A25 result to increase one value MAA25125681
Originally Posted by chandy123987
Please Login or Register to view this content.
Range will vary not constant may be b5 or c20 or d50
i will copy from one cell and paste to another cell, value to be added by one
Then adjust it for yourself.
Please see attachment. Use 'Ctrl + c' to copy and 'Ctrl + v' to paste.
The forum won't let me paste the code I wanted so I've attached it in a workbook. You can assign a keyboard shortcut to it (e.g. Ctrl+Shift+V).
WBD
it is working well Wideboydixon. Thanks
How about my solution chandy?
great Huuthang_bd, now only i saw that. Thanks
But this will change another column numeric value too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks