First off, sorry for the one off question.
My district has tasked me with assigning serial numbers counted at my site with the partial outputs from their SAP system.
So, after extracting my site's inventory and inserting my counts into it for conditional formatting compare-n-contrast highlighting. I noticed that my 30 digit Chromebook serials are cut off to the last 12 digits leaving 18 out.
Finally. After four weeks of hounding the inventory manager and one week before deadline, he tells me I need to line up the old, broken, serials with my new, correct, ones in a fresh spreadsheet.
Now my problem is that we have over 400 Chromebooks on site. I need to figure out how to script excel to search from The following
*Column A = Equipment ID
*Column B = Old Broken Serial
*Column C = Empty
*Column D = Part Description
*Column F = New Correct Serial
and I need to figure out how to move the contents of column F to column C using the partial data in column B as reference to find the correct data in Column F.
I had hoped it would be a simple equation and then propagate down column C, but no go. So now I am resorting to VBA to hopefully do this auto instead of manually. Any help folks would be eternally grateful.
My district has tasked me with assigning serial numbers counted at my site with the partial outputs from their SAP system.
So, after extracting my site's inventory and inserting my counts into it for conditional formatting compare-n-contrast highlighting. I noticed that my 30 digit Chromebook serials are cut off to the last 12 digits leaving 18 out.
Finally. After four weeks of hounding the inventory manager and one week before deadline, he tells me I need to line up the old, broken, serials with my new, correct, ones in a fresh spreadsheet.
Now my problem is that we have over 400 Chromebooks on site. I need to figure out how to script excel to search from The following
*Column A = Equipment ID
*Column B = Old Broken Serial
*Column C = Empty
*Column D = Part Description
*Column F = New Correct Serial
and I need to figure out how to move the contents of column F to column C using the partial data in column B as reference to find the correct data in Column F.
I had hoped it would be a simple equation and then propagate down column C, but no go. So now I am resorting to VBA to hopefully do this auto instead of manually. Any help folks would be eternally grateful.
