I have some macros that I could provide if that would help. Then the other tabs would look the same except would contain different data. My Fruit Purchase Date Quality DescriptionĪpples April 07 Quality for this shipment was excellent If possible, it would be cool if they were Bold and Centered :) It would look something like this: The Apples tab will have three column with row 1 labels "My Fruit, Purchase Date, Quality Description.". The tabs would be labeled Apples, Oranges and Bananas. So after I run the macro that you very graciously help me create, it would create a new spreadsheet with three tabs. In Row 1, I would like it to insert my custom labels for A,B,C such as My Fruit, Purchase Date, Quality Description. In Column C I would like it to have the Description In Column B I would like it to have the Date Then, in each of these tabs I would like to copy part of the record from the active sheet into the tab. In this example above, it would create three tabs called Apples, Oranges and Bananas. When it does, it will create a new tab for each of the items in Column B (Fruit). What I need is a macro that looks at this active sheet and copies this data into a new workbook. I would like to use your infinate macro creating wisdom to help me. America Quality for this shipment was excellentĤ5 Oranges Orange January 07 Florida Okayĥ6 Oranges Orange May 07 Florida Pretty GoodĢ3 Bananas Yellow June 07 Hawaii Damn goodĦ7 Apples Red February S. Let me first start by showing you a sample to go off of:Ģ3 Apples Red April 07 S.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |