good day Sir/Madam,
please help me find a formula on how to copy data on alternate cells, please see my attach file.
Thank you and GOD BLESS!!!
OK, this one is easy but for me a bit difficult to explain because I use Dutch language version and I'm not sure how thinks are called in the English version. So a wide explanation of which I hope it gives enough information for you to replicate it yourself.
1. select Column A
2. On tab 'start' you have on the right the binocular symbol (search and select or so?)
3. Choose there 'select special' (or something similar)
4. There comes a popup where you can choose 'empty values' (or such)
5. Do that and you'll return on your sheet with all empty cells in column A selected
6. Type '=A2' and give 'CTRL+ENTER'
7. Done!
Good luck!
Frans
Good day Mr. Frans Visser,
Thank you very much for your help, it helps me a lot.
Thank you also for your team and God Bless to all!!!