Hello all, I have a project at work I am trying to do where I need to copy an entire row to a different sheet based on a cell value.
I have been searching for answers and have tried various others' solutions but I can't seem to get this to work. I am quite new to VBA although I've been around Excel for awhile.
In column C of worksheet "Report-From-QB", there is an item list. I need to copy that item's row to a worksheet called "Data". There are quite a number of items in column C, and I need to sort it based on name, in this case "250000 (MT Solar Custom Order)". This action needs to be done multiple times for various items, then strip out all blank and/or impertinent cell to create a chart, but I guess that's a different topic.
I'm using Excel 2013.
Any help would be greatly appreciated.
I have been searching for answers and have tried various others' solutions but I can't seem to get this to work. I am quite new to VBA although I've been around Excel for awhile.
In column C of worksheet "Report-From-QB", there is an item list. I need to copy that item's row to a worksheet called "Data". There are quite a number of items in column C, and I need to sort it based on name, in this case "250000 (MT Solar Custom Order)". This action needs to be done multiple times for various items, then strip out all blank and/or impertinent cell to create a chart, but I guess that's a different topic.
I'm using Excel 2013.
Any help would be greatly appreciated.