Paste Cells in the same location below...is such thing possible?

[PP3321]

I do not upload excel file because I think this question can be answered without workbook.

I want to copy&paste multiple cells,
which have empty cells in between, like below.

When I Copy and Paste, it just copy the cell values,
not empty cells:
ABC

I want to keep them separated like:
A B C

Is it possible?

 

[PP3321]

Sorry I forgot to mention

I can not copy all cells including empty cells.
Because they contain values, which I do not want to copy.

I am looking for way to special-paste,
which takes into account empty cell.

 

[PP3321]

I am sorry if I offended some people. I get the message below.

Do you need excel workbooks uploaded for simple question like this too?

What I meant was if I am asking for complex solution with complex problem then I should upload the workbook.
But with my simple question, I thought it would be no problem if I did not upload it...

This is still a difficult question. I have googled it but could not find any answer.

 

[NARAYANK991]

HI ,

I think there is no need to upload a file , since your original post made it clear , at least to me , what you were looking for.

I think VBA would be the only possibility.

Narayan

 

[Luke M]

While I'm unsure whether you're wanting to copy/paste the cells with values, or the blank cells, it does sound like you're wanting to paste a discontinuous range into another discontinuous range? If yes, then as Narayan said, VBA is the only way.

 

[NARAYANK991]

Hi Luke ,

From what I can understand , the copy will be of cells B3 , D3 and F3 , assuming the row number is 3.

When these cells are selected , copied and then pasted to say , cell K13 , then they should be pasted into cells K13 , M13 and O13.

When done using the normal CTRL C and CTRL V , they are pasted into K13 , L13 and M13.

Narayan

 

[Luke M]

Thanks Narayan. If that's true, and cells to be copied to are aligned vertically with cells you're copying from, you can do this trick.

Select cells: B3, D3, F3, K13, M13, O13.
From Home Ribbon, go to Editing - Fill - Down.

 

[PP3321]

@NARAYANK991
@Luke M

Thank you so much for your answers...!

1.I press-down CTR + click to select discontinuous range in Table A,
which is identical in Table B.

If I could paste discontinuous range , I thought I would save time...
*Below is the example of my report...

So VBA is the only option...!

Thank you again!!!!!!!

 

[Luke M]

With the above layout, I think the second method I proposed will work perfectly for you. But, if you want to go with VB, that's fine as well.

 

[PP3321]

@Luke M
Thank you...
I have tested your method but I still cannot get it working.
I must be doing something wrong.
I will keep experimenting...
Thank you!

 

[Luke M]

Select these 6 cells:


Then go to Fill - Down


Final result

 

[PP3321]

Hi @Luke M
Thank you for your reply.
I was not reading your instruction properly.
If the order of selection is not right, it does not allow me to fill-down.
It is interesting.
Thank you for teaching me this trick.