CSEGUIN1973
New Member
- Joined
- Feb 25, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
First off, I'm a VBA newbie (Covid cancelled my class! )
For work, I have a two Summary worksheet workbook that has a Pending and Completed tab. My boss wants this also divided into separate tabs by brand while still maintaining the information in the summary tabs so this is a copy not a move.
I need to know the code and how to add onto it as new brands are added. I got it to work but it brought over plain text with no formatting or objects that are part of the row. I need the code to drop new entries into the next available line on the Brand Worksheet.
I know this is a lot but I'm super stuck. Can't wait until I learn and can answer these!
Since this is a work computer, I'm locked from making the mini sheet so I've attached images. I can contact with my email and provide a copy. Of course this is a fake document so I need to make it translatable to my real one.
Help!! <3
For work, I have a two Summary worksheet workbook that has a Pending and Completed tab. My boss wants this also divided into separate tabs by brand while still maintaining the information in the summary tabs so this is a copy not a move.
I need to know the code and how to add onto it as new brands are added. I got it to work but it brought over plain text with no formatting or objects that are part of the row. I need the code to drop new entries into the next available line on the Brand Worksheet.
I know this is a lot but I'm super stuck. Can't wait until I learn and can answer these!
Since this is a work computer, I'm locked from making the mini sheet so I've attached images. I can contact with my email and provide a copy. Of course this is a fake document so I need to make it translatable to my real one.
Help!! <3