new sheet

Hi everyone, I am very new to programming, only having dipped my toe into Python and VBA recently. I have a data set from work that I plug into my first sheet. In my macro I: 1) Create a filter and filter the data. 2) Copy and Paste Special to a different sheet to only have the values...

Hello everyone! I'm creating a report using a pivot table that when users double click their name and dollar value, a separate sheet will be created with data only pertaining to their name. This part is done. However, I also want one of the columns, dubbed "Action List", to have a pull-down...

I have a sheet made into a form with some check boxes included. If I select all the relevant columns, create a new sheet, and paste into cell A1 - all of the information carries over just fine. You can still select cells and check the boxes in the new sheet. However, when I record this action...

I have a Sheet called Master... which is a report with 9 task. is there a way to move each task to another sheet that is named for that task... the names are shortened to the two Words because of size restrictions. the task name is in D:D (the lengh of the report is longer some weeks) i need...

Hello, after fooling around with coding for awhile I have realized that I need to get an Excel Macro book to understand all of this. I have realized that just "hitting the record button" doesnt work. you have to actually know how to code in order to get your macro to do exactly what you want...

I have very little experience with VBA and I am certain my question will have an easy answer. I have seen posts related to mine and after trying about a dozen, I'm still having trouble. All I have been able to do is create a macro that when run, cuts and pastes the cells into a new worksheet...

I am trying to write a macro that once the warehouse guy is done for the day can create a new sheet titled 'the current date' totals, then export all rows that have x in column A from a sheet called 'the current date' to this new sheet. I have the template done for him and a macro that creates...

I have a number of worksheets that are used as source data for pivot tables (one per table). Ideally I would like for my vba to add a new sheet for the pivot table and rename it accordingly. Right now the code adds a new sheet based on how many sheets there are. More specifically...

Relatively new to VBA (so labels help a lot), thanks! I am trying to create a macro to track monthly changes in costs. A unique key requires columns D, F and J (community, plan and option). If there is a difference in column Q I would like to copy it to a third sheet. If a row has been added or...

I've got a complicated document where a certain type of sheet relates to other fixed sheets. I want the capability to add in a new sheet of the first type using a macro. How would I go about designing this? It needs to include various macros that define its relationship to other sheets. This is...

Okay, I have a sheet where you scan some barcodes and then press a button. Once the button is pressed, a bunch of macros start and ultimately the end result is a pivot table on a new worksheet. Once the table is created on the new worksheet, the final step is a UserForm that pops up and tells...

Hi i have a workbook with 21 worksheet. i was trying to write a macro that would add a column at the beginning of each sheet with the name of the month entered by the user. Here is my code, i don't know what is wrong with it but all i does is add 21 new column in sheet 1. Sub Month () ' ask...

I need help on a macro. I want to copy the current sheet to a new sheet with a pop up box asking for the new sheet name. Then I want to copy all cells on the new sheet and paste as values to remove all formulas. Thanks in advance for any help you can give me.;)

Hello out there Excel world.. I don't know if my question might sound dumb, but i'll be pleased to know if there is a macro with which one could call and create a new sheet from an existing template. The new sheet must have references to a specific row in other sheets in a separate workbook...

Hi, im trying to add a new sheet to a workbook at the moment im using this Dim WS As Worksheet Set WS = Sheets.Addwhich fine but how can i make the new sheet be called "results" i was using this method bellow but i heard its not best practice Sheets.Add.Name = "results"cheers

I added another sheet to my workbook and now my macro buttons are messed up, even though I am referring to the worksheet by sheet number. This is the problem function, it is supposed to pull a random percentage of the rows on the FromSheet, then copy them to a temporary hidden sheet, Sheet7...

Explaining the story may help you guys understand my needs... I am a gym coach. My athletes will come into the gym, perform their session and then head to my computer where they will enter their load from that day. I want it to be as simple as possible for them. I want a drop down menu for...

Hello, I am trying to correct a very simple macro for filtering and copying data from "Master" sheet to a second "Complete" and third "In Progress" sheet. I would like to filter rows denoted with the data "C" in the "Master" sheet to the sheet "Complete." Rows with data "IP" will be filtered...

Hello all, I managed to find this below macro to check for duplicates over multiples sheets. I was hoping that someone may be able to help me amend it to paste the identified duplicate (whole row) to a a different (existing) sheet (within same workbook) in a particular range, beginning on the...

Hi, I want data to populate on "sheet 2", from "sheet 1". That means that when I insert a new row in "sheet 1", I want "sheet 2" to display the data that has been entered into the newly inserted row on "sheet 1", without having to re-enter the formulas in "sheet 2". I'm fairly macro -...