Hello,
I am hoping that someone out there can assist me with my project, because I have never done this, I have read all about macros so understand the concepts but am getting frustrated.
I have been given a worksheet that I need to create a macros for. What needs to be done is this macros needs to filter the word in column A, "North" and then filter again in column B for "HCF" (each row contains information in columns a-g). Once that has been filtered, it has to copy those rows that were filtered, go to the worksheet labelled "North", navigate to the row named "HCF", and paste it to the next available blank row below that header. Then navigate back to the "Master" worksheet and deselect the "autofilter" function, so that the master copy looks untouched.
just for additional info, this workbook contains 4 worksheets labelled: master, north, south, and east.
and then in north, south, and east there are at least 4 sections that they are divided into "HCF, HDA, ADU" etc. and the information from the master copy needs to be divided by their unit (North,South, or East) and then subunit "HDA,HCF" for example.
hope this makes sense and that if someone can provide me a code for the first one that i can figure out the rest, i hope!
thanks alot for who reply to this message.
Bookmarks