BlackThorne
New Member
- Joined
- Nov 16, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
please I need help with a little work project in Excel.
We have parking cards for our employees (300+) and they are valid only till the end of the year, which means we will have to print out new ones. I have uploaded image of what our cards look like in Excel, two fit on one page (A4).
My problem is I have 300+ licence plate numbers downloaded from our internal database as another excel sheet (SPZ on the image) and I basically need all of them filled one by one to the cards.
Solution I came up with, but am unable to write a macro for is to:
1) Copy first two licence plate numbers from top down list and insert them to the cells I need them in.
2) Print the page (two parking cards)
3a) Delete first two rows and repeat from 1) till blank (end of list)
3b) Copy next two licence plate numbers below and repeat from 2) till blank (end of list)
- I did and tested first two points as macro and it works, but with my limited knowledge of VBA I am unable to write a loop for it or make it stop when comes to blank.
Can you please help me? Or can you think of any other solution for these 300+ licence plate numbers to be printed out without need of manually copying them to cell and print and repeat?
Thank you very much for your help.
please I need help with a little work project in Excel.
We have parking cards for our employees (300+) and they are valid only till the end of the year, which means we will have to print out new ones. I have uploaded image of what our cards look like in Excel, two fit on one page (A4).
My problem is I have 300+ licence plate numbers downloaded from our internal database as another excel sheet (SPZ on the image) and I basically need all of them filled one by one to the cards.
Solution I came up with, but am unable to write a macro for is to:
1) Copy first two licence plate numbers from top down list and insert them to the cells I need them in.
2) Print the page (two parking cards)
3a) Delete first two rows and repeat from 1) till blank (end of list)
3b) Copy next two licence plate numbers below and repeat from 2) till blank (end of list)
- I did and tested first two points as macro and it works, but with my limited knowledge of VBA I am unable to write a loop for it or make it stop when comes to blank.
Can you please help me? Or can you think of any other solution for these 300+ licence plate numbers to be printed out without need of manually copying them to cell and print and repeat?
Thank you very much for your help.