Auto populate to sub-sheet
Good day everyone...
How to populate from Main sheet to sub-sheet based on Area.
If i enter "Bank" on Area column then Case Number will generate
auto sequential number base on the last Area name and
Bank sheet will auto add/update also.
Please help me either by formula or vba..
Thank you...
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Main" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a value in column A and press the RETURN key.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
A different approach...Please Login or Register to view this content.
Last edited by dangelor; 06-29-2019 at 10:50 AM. Reason: Changed copy format
Thanks guys...
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks