Unable to copy the rows from excel A onto an excel B which has hidden rows

[mani_nsn]

Hi,

I have an excel A with multiple data rows and an excel B which has also multiple data rows but excel B has so many hidden rows.

Both excel A and excel B has filters applied also.

When I copy paste the entire worksheet from excel A to excel B, the data is not captured correctly in excel B and many of the data in excel A goes and hides into hidden excel B rows.

Please guide me on how to resolve this issue.

Thanks
Mani

 

[Asheesh]

Hello Mani...

First of all welcome to the forum..

Why dont you create a copy and move that sheet from excel A to excel B...

 

[mani_nsn]

Hello Mani...

First of all welcome to the forum..

Why dont you create a copy and move that sheet from excel A to excel B...

Thank you Asheesh.
I had already tried the same... copying excel A and pasting onto excel B but the issue is that the some of the rows in excel A gets copied inside the hidden rows of excel B.

Also i cannot make changes in excel B as it has some other department names too mentioned.

Hope this info helps.

Thanks
Mani

 

[Asheesh]

well i was talking about a different approach...neverthless, let me check if i got your correct...

So all you want to do is to copy visible cells from excel A to excel B..??

 

[mani_nsn]

well i was talking about a different approach...neverthless, let me check if i got your correct...

So all you want to do is to copy visible cells from excel A to excel B..??

Yes, you are right...
I want to copy all visible cells from excel A to excel B.
Note : It should not disturb or get overwritten on any of the hidden rows in excel B.


Thanks
Mani

 

[Asheesh]

please see this -

http://www.mrexcel.com/forum/excel-questions/687936-copy-paste-hidden-columns.html

 

[mani_nsn]

please see this -

http://www.mrexcel.com/forum/excel-questions/687936-copy-paste-hidden-columns.html

Hi Asheesh,

I tried the below steps but does not seem to work as per my requirement.

Select the data on Excel A...then press ALT +;
then CTRL + C
then go to Excel B..where you want to paste
then press CTRL + V or paste special as you need..

Thanks
Mani

 

[Asheesh]

I had partially understood your query...I later tried it once but Alas ! all in vein...please read the link in comment no 6

 

[mani_nsn]

I had partially understood your query...I later tried it once but Alas ! all in vein...please read the link in comment no 6

Ok. No probs.

Anyway please let me know in case of any possible solutions.

Thanks
Mani

 

[ashish mehra]

Hey Mani,

I am afraid no one would be able to help you out unless you post both the files to play around.

Regards,
AM