I am a complete newb in macros but have been given a task and have no idea how to do it.
We have pulled a large amount of data into one excel spreadsheet and am looking to do the following with it.
I would like to do a search through the entire spreadsheet say by the first 3 digits of a postal code i.e. m5v. I would then like it to grab each row that has an m5v postal code and move all that data to another worksheet.
My columns used are a - q and the postal code field is in column g across the entire worksheet.
So let me be fully clear on what I am looking for.
I need to have the macro search column g for a specified 3 digits i.e. m5v, then grab the entire row of information and store it in another worksheet.
Any help would be appreciated.
Welcome to the forum
a search on the forum found one example
this should get you started and give you an idea of what other infoormation is require to completer the task
There are currently 1 users browsing this thread. (0 members and 1 guests)