How to do the following copying?

C

cyberdude

Hi,

I have a spreadsheet in which

cell C2 contains =A1,
cell C3 contains =A3,
cell C4 contains =A5

may I know what operation I can do, without using macro, such that
cell C5 contains =A7, cell C6 contains =A9, cell c7 contains =A11
etc? Thank you.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
How to delete ALL cells containing the same data 1
issue with "left" 5
Excel Fill issue 2
Data Validation, VLookup or If ??????? 3
Find the first & subsequent cells to contain text in & repeat 0

Top