Copy Rows

.
I am not familiar with the Mac. However, in Windows Excel, this will work :

Please Login or Register  to view this content.

Hi Logit,

Thank you so much.

Actually I did improve my question (to better understanding) and I'll send here to you:

I'm using Microsoft Excel for Mac and I have this issue to solve.

On the sheet "Data" I have movements and for all records that appears "1" on column "Y" I need to copy information from columns D and E (from that sheet) to another sheet, called "Estatistica".

I don't know how to upload my file for you. This is my first time on the th forum.

Please help me on that, too.

Thank you very much.

I wrote another post called "Copying rows from a Worksheet to another - Mac Excel", and there I could upload my file

.
Tested here and confirmed works :

Please Login or Register  to view this content.

Wooooowww !!!!
U-huu !

Thanks, man/woman

You just save my life.

If you need something I could help you, plese, let me know.

Thank you very much!!

Glad it worked for you.

Cheers !

I beg your pardon, Logit

I put the information in columns A and B using the Macro you made for me.

Perfect.

Doing this, I would like after putting in columns C, D, E, F and etc., data related to those written in A and B.

The problem is that every time I run the Macro it erases everything in columns C, D, E, F and so on.

Hence I lose all formulas (Vlookup, for example).

Can you give me that little help?

Thanks

.
This line erases everything prior to copy and paste :

Please Login or Register  to view this content.

OK !
Thanks

Hi Logit,

Here I send the "great piece of work" you've been done for me.

Thank you.

Now I have this final issue: it is possible to run the macro CopyYes every time the user change cells G5 or H5 at "Estatisticas RH" sheet?

Thanks, again

Hi, I received thus message from "the other" forum.

It was my mistake, because I did not know that is not allow to have same issue in different forums.

So I stoped to talk to them and keep conversation here.

Please, tell me what I have to do to go further here, because I do not understand how to solve that.

Be wainting.

Thank you

Sorry,

I found, besides you, just one post at "MrExcel.com" and I already ask them to delete it.

Need to understand to fix it, here, and go on.

Please explain me what to do more.

About my last question posted here on Excel Forum: it is open yet, do I have to write another one, will I receive answers ?

Thank you

.
Stumpoc

In your next post, list all the URL's where you have posted the same question on other forums. Then we can proceed.

https://www.mrexcel.com/board/thread...value.1171088/
https://www.facebook.com/groups/138136370278192 (facebook group)
https://www.facebook.com/groups/488041698308743 (facebook group)

I do not remember any other forum where I posted the same question.

If there is any other I really don't remember, but I believe not.

Thanks for your help.

.
Paste the following in the Estatisticas RH sheet module :

Please Login or Register  to view this content.

Hi,

Something is going wrong and I'm not able to solve it.

1 - First I use "View Code" with right mouse click over my where appears the cells (H5 and G5).
2 - Then I do "Insert > Module" to create a new modulo
3 - Finally I write that code you sent me

Here I send screenshot showing step-by-step.

Even so, I does not work.

Am I doing anything wrong?

Thank you

I hope this process is the same in MAC Excel as it is in Windows Excel ...


Right click the sheet tab for Estatisticas RH

Select VIEW CODE

Paste the macro there. You already have a FUNCTION in this sheet module ... so ... after pasting it should look like this :

Please Login or Register  to view this content.

YEAAAHHH!!!

Yor the best!

Thank you so much!

Glad it works for you on the Mac.

Cheers.