worksheets

Hi everyone I have a question in regards to hiding worksheets.. i do know how to do this in the usual manner. although i was wondering is there a way using vba to hide a worksheet, and then show the worksheet if a user clicks on a button, then once the user goes back to the main dashboard the...

Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...

Hello Everyone, wondering if someone might be able to help me out with a formula I am having trouble with. I have researched the formula extensively on-line and can't seem to get it to work. Basically, I am trying to use a sumifs formula with multiple criteria that sums across multiple...

Looking to get the average of a single cell over multiple worksheets, but I need it to always go to the last worksheet as I will be adding more sheets. =AVERAGE(Sheet1:????!A1) Thanks

Hi, I found this neat VBA code to protect / unprotect all worksheets without having to do each one manually. See below. The only problem is, it only allows; - Select Locked Cells - Select Unlocked Cells Whereas I want another 2 options to be included as well; - Format columns - Format rows Does...

My workbook contains many sheets and before closing the workbook I would like to replace the same cell on all worksheets with the same text. For example, certain cells replace all that start with "rateid_???". I have tried the following code but receive an error on the IF ws.Range…… row. Could...

Hi all, Need some help adding some coding to loop through tabs in another workbook. The code opens up a file(s) in a specific folder and the aim is to just copy all data in all tabs into one tab within DataDump file. Sub Execute_Files()Dim objFSO As Object, objFolder As Object, objFile As...

I have a workbook with 2 worksheets. The first worksheet is named "COURSEID" with a list of course IDs, the second worksheet is named "Template" that has formulas. I would like to copy the Template worksheet, and name the copies from a list in COURSEID from A2:A77. The VBA code below is not...

i need to re-arrange the tabs so that it saves the PDF in that order....is there way to do this without manually moving the worksheets? i tried re-arranging the sheet names in the vba array code, but that didnt seem to do the trickl

Hello, I'm looking for some code that will: 1. Evaluate my data set in my "test" worksheet. The header for my data set begins in worksheet("Test"), cell A3, and the size of the data set varies weekly. 2. Create new worksheets (and name the new worksheet) based on the cell content is the...

I have a excel file that has 7 worksheets in it. I have a button set up that says Sort data. I want to be able to use one button (Sort Data) to sort data over those 7 sheets but each sheet be alphabetized by its self. Also i want the cells that are to be sorted on each sheet to be: A3:AL32 and...

Hi, I've got some code that is looping through multiple workbooks (with multiple worksheets) to copy data however it's pulling ALL the worksheets within these workbooks and i'd like to limit it the copying to specific ones. Is there a way to list the worksheets that i only want the code to...

Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with 7 worksheets with several Macros. There is also a Macro in the "This Workbook" that runs every time the workbook is opened to set all the workbooks to a generic condition. Recently I discovered the need to use the...

This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another? What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information...

Hi there, I'm working on developing a spreadsheet that locks down all data entered to text only - and contains no formulas, and will not allow recording of macros. So I locked down the format of the worksheets to text, and the structure of the spreadsheet to not add more worksheets, and...

Hello! Im having a bit of a problem with my code, and it might be very easy for you. Im very new at this. Problem: I want a commandbutton that create new worksheets. The new worksheets gets its name from the value in CELL B12. And when it have created the new worksheet, it should copy a range...

Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook containing 7 worksheets. One of the worksheets uses LOOKUP to access a number from one of the other worksheets for each entry on the first worksheet. After entering new data in Row 95 of the worksheet, the LOOKUP...

Hi all, My VBA used to run with no issue, but recently seeing "System Error &H80070057 (-2147024809)" VBA simply protect all worksheets in the workbook. Am currently using Office 365 (running under Win10) . Any clue what could have caused the issue? many thanks...

I have an excel workbook with 6 worksheets. Each worksheet has a different header. Each week, I want to be able to change 4 of the worksheets footers without changing their headers. When I group the 4 worksheets and change the footer; it changes the headers too. Is there a way to change 4 of...

I have a workbook that has 14 worksheets. I'm looking for some code that will split these worksheets out into individual workbooks while retaining formatting. I did find some code that does essentially what I am looking for: Sub Splitbook() 'Updateby20140612 Dim xPath As String xPath =...