worksheets

No doubt this has been covered before is there a VBA to hide the headings in all worksheets Thanks everyone Regards Jason Bing

I have an Excel 2010 workbook (let's call it 'Master') with many worksheets, whatever name. Each worksheet has data structured as shown below. One of the columns has an identifier, such as a supplier code. Both sheets on the Master are sorted on Column1_header. Note: The actual structure is...

Hi guys I am trying to cycle through all the worksheets in my workbook and copying all the unique values from Column C into a new worksheet. Is there a way to get a macro to do that instead, and then paste it in a new worksheet so that: - the other worksheet name is in the header and, -...

So, I have a code that combines ALL worksheets and puts them in a combined worksheet. I just want to combine specific worksheets called 'US Data' and 'Canada Data' and not combine the rest of the worksheets I need to add - this is the code I have, do I need a new code or.... ? Any help would be...

Hello I'm looking to copy specific worksheets to another workbook. My method below works but the final sheet "Chart data" I would like to just be values rather than keeping the formulas. Note that the other worksheets being copied are charts and all drive from the chart data sheet. Sub...

Hi. I have a file with data on two separate worksheets. They need to stay on separate worksheets. But I need to print both worksheets on a single page, without scaling either. They're not large, they will both fit onto a single sheet without scaling. I did an internet search, my friend...

I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on. What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned...

Hi All I have an excel workbook with around 6 worksheets, when the final user presses a button I want all the cells in every workbook to be formatted to "Locked" and then every worksheet locked with a password. Basically once the final user signs it off the workbook can no longer be edited...

Hi, help please with creating worksheets in a workbook Im using Excel 2016 I have a VB to create new worksheets based on a list of names on a summary sheet but I would like the new worksheets to be to set layout including column widths, formats and formula. Is the easiest way to do this to...

Hello friends, I searched a lot on the internet and found countless similar solutions, but not exactly what I was looking for. I ask for your assistance. I have a workbook with 38 worksheets. I made myself a UserForm1 in which I inserted 28 worksheets with their names. These names are with...

I have multiple worksheets with item names in column A and their corresponding colours in column B, of each worksheet. Each sheet may often have different item names in column A, same names but different colours and their positions may change based on their ranking. I want to compile a list of...

I am using this code. Sub CleanUp() With ActiveSheet.UsedRange .Value = Evaluate("if({1},trim(clean(substitute(" & .Address & ",char(160),"" ""))))") End With ActiveSheet.UsedRange End Sub How can I apply it to all worksheets in the active workbook? If there is ever an error...

I have a document with worksheets named WK01 to WK52. Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change. In column E of the week worksheets there will be a name of a product, column F the...

I have two different workbooks that has identical table headers. It's used for timesheet registration but I have 2 computers set up so people don't have to be in line. I've created a connection between the 2 workbooks so I can pull the tables to a "Master" workbook. I've manged to get the two...

I have 1 workbook with 8 worksheets. All worksheets are set up in the same format using columns A - Y. Is there any way that I can easily combine all worksheets into 1? On the new worksheet in column A I'd like the name of the orginal worksheet and the actual data to be from coumn B - Z. Thank...

Hi is there a way besides using .Formula to say sum all the B6's on the worksheets in a workbook expect for sheet1, and put the results in B6 on sheet1?

My company has a xls file on a onedrive folder. How can I link a worksheet to one of the worksheets in that workbook so it always is up to date? -Eds

Hi, can you please help me with this. thank you I have 21 worksheets I will refer to all my worksheets by codename Cells A2 through A21 of Sheet1 contains a list of PO Numbers. I want worksheets 2 through 21 to be renamed based on sheet1 cells A2 through A21. example : if Sheet1, Cell...

Good Morning I need to understand how to write macros to automatically resize worksheets to display the same on all computer screen sizes. theamateur1939

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.