I need to copy data from one excel sheet to another.

source sheet

1
2
3
4
5
6

the data is to be copied in the following format

1 2
3 4
5 6

the copy paste method does not allow this because the regions are different.
Can this be done in any other way.

Recommended Answers

All 2 Replies

I need to copy data from one excel sheet to another.

source sheet

1
2
3
4
5
6

the data is to be copied in the following format

1 2
3 4
5 6

the copy paste method does not allow this because the regions are different.
Can this be done in any other way.

You should post this to "Forums > Tech Talk > Microsoft Windows > Windows Software" forum. You might get your answer from there.

hey...thanks for the suggestion.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.