CODEWITHSUNDEEP
excel
hp58
hp58

Reputation: 135

Copying Cells in Excel

I don't know if stackoverflow is the right place for this question:

I have an Excel table with values in the cells C3, G3, K3 and so on... Now i want to copy these values in the cells B27, B28, B29 and so on...

Can I manage this in the Excel command line or do I need to write some VBA code? (I'm using Office 2010)

Upvotes: 1

Views: 162

Answers (2)

deusxmach1na
deusxmach1na

Reputation: 368

Put this in cell B27 and copy down as far as you need:
=OFFSET(C$3, 0, (ROW()-27) * 4)

Upvotes: 1

Derek Risling
Derek Risling

Reputation: 364

I may be misunderstanding the question, but in excel you can simply reference a cell to get it's value, so in C3 enter =B27, and the value from C3 will appear. Repeat for the other cell values you'd like to copy

Upvotes: 1

Related Questions