I have a huge report in Excel that needs to be put in list format. The Customer ID and name only appears at the beginning of each section. Does anyone know how to write a macro or code to copy the ID down through each related line in the section? Attached is a before and after shot of a slice of the report.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…