worksheet

Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125...

Hi Quick question I'm trying to copy a data from one worksheet to another. I can now copy the data the only problem is it has a formula. What im trying to paste is the values only and no longer will copy the formula. Here is my code Sub Button1_Click() Dim source As Worksheet Dim...

Hi Excel Experts, I am struggling with how to reference a Worksheet in VBA and hope someone can help me. I have a macro enable book where the code opens a different Workbook and copies the first worksheet to the macro book. Once the code has done its thing I need to sort the results. I had...

Hi, Is there a keyboard shortcut to view all the worksheets in a workbook? I know how to right click on the <> arrows to view all the worksheets but wondered if there was a shortcut? Thanks Peter

Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc

I have A combo box named comboWs that has a list of all 63 worksheets in the workbook, but all are hidden except the active one. Combo's output is on worksheet named general.switchboard in cell "O54" (this worksheet is visible=true). I want to go to the worksheet selected in the combo. I've...

I have a macro to save a worksheet and protect it. It then also saves the new worksheet as a PDF. I want to save the PDF into a particular subfolder called "Invoices" The sub folder will always be in the main folder. I cant use a spefic path at the main folder needs to work on different...

On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible...

Hi I am looking to format my worksheet with different colours based on a data validation drop down list. I currently can get the drop down cell to be the correct colour but would like the whole worksheet (Columns B-J, Rows 2-67) to be different colours. Any help will be greatly appreciated...

I have a vba which creates a new worksheets whose name is dependant on a cell value. At the same time it also created a PDF file of the same sheet. What I want it to do is also protect the newly created worksheet only. I have tried a few things to no avail. This is what I have so far Sub...

Still struggling a bit. I can run the code below but the target workbooks columns are not sized the same as the primary sheet. There seems to be many ways to copy so i think im trying to mix them is why i keep getting a object error. Any suggestion would be helpful in the code below i've...

I've done this before, but struggling with the details of how. I have created a default worksheet that opens when Excel starts stored in my XLSTART directory. I need to create a default worksheet so that when I insert a sheet, the new sheet is formatted as I intended. I have tried saving as a...

Hi, I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot...

Hi all< I have a vba which creates the new worksheet no problem. But I want to add to the VBA by having it also save as a pdf file in the following location: Ged\Disability\2019-2020\invoices. I also want the PDF file to be named the same as the worksheet that was created. This is what I...

Hi, I am not sure if my title explains it correctly but code in cell K33 is shown below. On my worksheet i have the following worksheets Income 1,2 & 3 Expenses 1 through to 8 Here is an emample of my issue. Worksheet Income (1) has a running total shown in cell G32 There is also a running...

Hi all, I have an excel workbook that has multiple tabs, and once a week I have to mail 2 of the tabs (worksheets) to our Plant manager, I use a Mail Sheets Array and a macro button to do this and it works fine, but recently, I have added a "Charts" worksheet, and when it makes the temp copy of...

Thanks for visiting mypost. I have encountered a difficulty in applying sumif function. The raw data is likethis. In worksheet 1, thereare 100 companies' name on one row and 87 expense items on one column Worksheet 2 is atemplate. I need to create a worksheet for each entity based on...

Hello Once Again. I've been working on a project that I previously posted here. Looking at it from another angle, I think I found a solution where-in I need help. Here is the code I am Using Sub SheetCompare() Sheets(6).Activate '6 is the main sheet 'Cells.Clear 'and clear...

Hi I've built a code that searches through a list (rngWB) of excel workbooks and produces them as PDFs. The code works well, but insists on saving the individual PDFs to my Documents folder. I want them to be save to a folder in my documents, but that is further named by the contents of a...

I need to link a cell on one worksheet to a cell on another. the last line has syntax errors in it and I don't know how to fix it. the code finds "what" in worksheet 218500Amort. range C12:C500. I need worksheets("218500").range("b22") to have a formula rather than directly = ra. can someone...