Hello,
I need a formula in E4 that will sequence the entry in E3. (see sample sheet)
Example:
If I enter this number in E3 column/row 23LBFM0001 then automatically it sequence from E4:E37, I3:I37, M3:M37,Q3:Q37, U3:U37 that showed show like this:
23LBFM00002
23LBFM00003
23LBFM00004
23LBFM00005…… etc.
Can this be done in VBA? If not, its okey as long I have the formula in the E4:E37…..U3:U37.
Thank you in advance!
Formulae?
Formula:
Please Login or Register to view this content.
Or:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Are you still using Excel 2010?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes. I have excel 2010.
Why? is there a new one
There have been many new versions - Excel 2013, Excel 2016, Excel 2019, Excel 2021 and Excel 365.
To Sheet2 code module.
Please Login or Register to view this content.
Last edited by jindon; 10-12-2023 at 10:23 AM.
Thank you all!!
I appreciated it.
One thing,
When I deleted the entry in E3, it did not delete all the entry in E4:E37 where the formula is.
Thanks.
How do i cut these? It gives an error compile. Thank you
Please Login or Register to view this content.
Compile error exist: Set range is too long.
Please Login or Register to view this content.
When I tried to cut the range, it said i need a bracket.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks