F
frustrated worker 2
The information offered earlier was perfect, and as much as I try to understand how visual basic works I still have a difficult time
The spread sheet that I have will always have two sheets compiled with "raw data"... from these sheets the macro is set up to find the different part numbers and create a whole new sheet per part number listed (in raw data). Although every set of raw data will have different numbers of part numbers creating varying number of sheets. I still want to format all of these sheets (with in a macro), but how can I tell it to grab all of the sheets if it's 2 or 200 additional sheets and format away.
The spread sheet that I have will always have two sheets compiled with "raw data"... from these sheets the macro is set up to find the different part numbers and create a whole new sheet per part number listed (in raw data). Although every set of raw data will have different numbers of part numbers creating varying number of sheets. I still want to format all of these sheets (with in a macro), but how can I tell it to grab all of the sheets if it's 2 or 200 additional sheets and format away.