Forum

Notifications
Clear all

Copying of Data

3 Posts
2 Users
0 Reactions
63 Views
(@elicozeac)
Posts: 18
Eminent Member
Topic starter
 

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!!!

 
Posted : 10/12/2017 9:49 am
(@fravis)
Posts: 337
Reputable Member
 

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

 
Posted : 10/12/2017 12:36 pm
(@elicozeac)
Posts: 18
Eminent Member
Topic starter
 

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!!!

 
Posted : 12/12/2017 2:31 am
Share: