new tab macro

I need some help - google hasn't led me to anything useful :( In my workbook, Sheet1 is a template used to analyze some data. Sheet2 is a list of values. My current macro asks a user how many times they need the template copied, and then copies Sheet1 as a new tab at the end of the workbook the...

Hi, I would like to change the destination to be a new tab rather than the imported data tab. I want to no longer have an imported data tab, rather a new tab each time I import or extract the data. We get multiple work orders or different locations. Once solved I will post the next part as a...

Hi All, Not sure if this is possible but thought I would ask and see if anyone knows a way of doing it. I have made a a spreadsheet for imputting payments for our clients which has several buttons with Macros that turns the information that is put into the spreadsheet into reorts and CSV...

Hey guys first post, sorry for any transgressions. So, I'm trying to copy the results from a pivot table to a new tab that is created and named by the macro. The problem is coming with the creation and naming of the tab. After the first run it returns with an out of range function. I understand...

Hey everyone I'm trying to design a workbook that will copy an entire rows data to a seperate tab once a dropdown selection (in that same row I'm trying to move) is switched to 'Completed' Is there a way that a Macro can be triggered once that "Completed" dropdown is selected which could...

Hello, I think this is a pretty big ask... but maybe people can just chime in on pieces and we can build from there? I have a worksheet with headings in row 7, a list of customers in column A, lists of products each customer sells in column B, and monthly sales information from columns C to N...