Create Macro to create worksheets based summary sheet
Closed
Russell
-
May 25, 2016 at 11:07 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 25, 2016 at 07:35 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 25, 2016 at 07:35 PM
Related:
- Create Macro to create worksheets based summary sheet
- Create skype account with gmail - Guide
- Create snapchat account - Guide
- Create a yahoo email account for free - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Create instagram account - Guide
2 responses
I encourage you to move to a DATABASE, and not a spreadsheet. A spreadsheet is for mathematical calculations, not keep inventories (not when they are of the size you have described!)
If you must stay on the spreadsheet, start the manual migration now!
If you must stay on the spreadsheet, start the manual migration now!
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
May 25, 2016 at 07:29 PM
May 25, 2016 at 07:29 PM
Greetings Gentlemen,
I hope that you don't mind me putting in my two cents worth but Russell may be interested in having a look at the sample file at the following link:-
https://www.dropbox.com/s/ppe9ukewz9po3e1/Teke%20%283%29.xlsm?dl=0
The code is one that I wrote for another Poster a few months ago and I believe it is a similar scenario to Russell's. Click on the button to see it work.
Russell, see if you can adapt it to suit your needs. Let us know if it works for you and post back should you require any further help.
Cheerio Gentlemen,
vcoolio.
I hope that you don't mind me putting in my two cents worth but Russell may be interested in having a look at the sample file at the following link:-
https://www.dropbox.com/s/ppe9ukewz9po3e1/Teke%20%283%29.xlsm?dl=0
The code is one that I wrote for another Poster a few months ago and I believe it is a similar scenario to Russell's. Click on the button to see it work.
Russell, see if you can adapt it to suit your needs. Let us know if it works for you and post back should you require any further help.
Cheerio Gentlemen,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
>
Blocked Profile
May 25, 2016 at 07:35 PM
May 25, 2016 at 07:35 PM
You're welcome ac3mark. I should get back to work now!