headsniper
08-27-2018, 06:13 PM
Hi all,
I am a newbie to VBA. I've been searching online how to do what I want to do, but I cannot get a definitive answer.
The worksheet I have has changing data every hour, which is also sent out on an email every hour as well.
I cannot send a template for my worksheet due to my company policy(my home pc also does not have excel). I will try to explain what I am trying to do with the best of my ability.
My template consists of user auxiliary data. The data needed highlights in red. What I do is I hide a cell, filter one auxiliary column data to red, set order from largest to smallest, then I copy that column and the previous data columns on to an existing blank sheet. I then clear the original sheet. I then hide the previously used auxiliary, so that I can rinse and repeat with the other auxiliary data, adding and identifier name two cells below the previous data, then I paste again. I do this until i have pasted all the auxiliary data.
The problem I am encountering is that since the data changes in rows at least adding one cell, the copy of the next data overlaps the previous ones. I am trying to set the code so that I can add an identifier/name two cells below the most recently copied data, and copying the new data right below the identifier cell.
My company is so stingy with the internet policies, that I cannot even read vba forums at the office. I have to copy the codes to my email, send them to my company email, and read it from there. Without excel on my own pc, this has definitely been a challenge to learn vba.
Sorry for the long text everyone. I am appreciative on any help given.
I am a newbie to VBA. I've been searching online how to do what I want to do, but I cannot get a definitive answer.
The worksheet I have has changing data every hour, which is also sent out on an email every hour as well.
I cannot send a template for my worksheet due to my company policy(my home pc also does not have excel). I will try to explain what I am trying to do with the best of my ability.
My template consists of user auxiliary data. The data needed highlights in red. What I do is I hide a cell, filter one auxiliary column data to red, set order from largest to smallest, then I copy that column and the previous data columns on to an existing blank sheet. I then clear the original sheet. I then hide the previously used auxiliary, so that I can rinse and repeat with the other auxiliary data, adding and identifier name two cells below the previous data, then I paste again. I do this until i have pasted all the auxiliary data.
The problem I am encountering is that since the data changes in rows at least adding one cell, the copy of the next data overlaps the previous ones. I am trying to set the code so that I can add an identifier/name two cells below the most recently copied data, and copying the new data right below the identifier cell.
My company is so stingy with the internet policies, that I cannot even read vba forums at the office. I have to copy the codes to my email, send them to my company email, and read it from there. Without excel on my own pc, this has definitely been a challenge to learn vba.
Sorry for the long text everyone. I am appreciative on any help given.