I have all these spreadsheets from different vendors and all of these spreadsheets are in totally different formats. Is there a way I can create one macro and apply this one macro to all spreadsheets to get me a standard format?
sounds a little daunting and would probably be a little convaluted. Would suggest that you create individual macros for the different layouts, then when that one file comes in you run that macro. You could setup a set with all macros in it and then put different command buttons for the different macros. Good luck
I created a macro for one of the vendor's spreadsheets. It works fine. On this spreadsheet, we have 4 products and each product has 5 SKUs. Next time if their spreadsheet only shows 4 products and each product has 3 SKUs. When I run this macro, it will not work because each product is missing 2 SKUs(they won't be listed on the same line). What should I do? I am new to macro so hopefully someone can help.
that's not a problem using record, you just have to modify the macro afterwards to fix it for repeated use. Go to the macro and select edit and select Ctrl + A (to select all) then Ctrl + C (to copy), then paste it back here in a post.
Ok so would really need to see your sheet or a sample of your data in order to help on making this work. So you could post a small sample of your data and the before and after, or else use one of the free file storage web sites. like this one: http://www.box.net/
I did clean up your code a little to remove the select statements and the scrolls