multiple worksheet

  1. D

    VBA to sort data across multiple worksheets (same range)

    Hi all As usual I have no idea where to start on this one. I have a workbook with a number of sheets in that I want to perform a sort on all of them. I would like to sort the data in A29:K100 (No headers) by column B (ascending) across all worksheets in the workbook. I don't know how many...
  2. J

    VBA - Creating Master List (from different worksheets)

    Hi All, I'm new the forum and have very limited VBA experience. Would really appreciate ANY help with my issue. Right now, I have 3 different sheets of data, with different number and order of columns. I need to create 1 master list that combines the data from 3 of these sheets, thought not...
  3. J

    how to write VBA code to apply a macro to multiple worksheets

    Hello Everyone! I have a code here(please find below) and was wondering if you could help out. I am using this code to delete all the blank rows in a worksheet , and this code works fine. The problem I am Having is that, when I run the code it only does it for the current worksheet I am on. I...
  4. czarpogi

    How to clear range in selected multiple worksheet

    Hi, I need some help in making this code short and simple. Is there a way to do that? Thanks in advance. Here's my code: [code]Sub ClearData() With Sheets("NPS") .Range("A2", .Cells(.Rows.Count, .Columns.Count)).ClearContents End With With Sheets("QFY") .Range("A2"...
  5. S

    Sorting Data Across Multiple Worksheets

    I have several hundred files, each representing a different date and each containing roughly 500 rows and the same columns. I would like to sort each of these files in the same manner (while adding a few extra columns with calculations) with the ability to then compare and analyze the sorted and...
  6. S

    VBA Auto filter

    I am trying to create an auto-filter on the first page of my workbook, the worksheet is named Index. I have created a dropdown box on this page with criteria that I want to filter against, on 8 different sheets in the workbook. I can't figure out how to reference the drop down cell on the...
  7. T

    How to make my VBA command run on several worksheets

    Hi, I have one workbook with several worksheets, however when i run it, it only run on one worksheet. Can anyone help me to make this code also run for other worksheets in the same workbook? Here is the code: Private Sub Workbook_Open() Dim LRow As Long Dim LName As String Dim...
  8. O

    Delete columns if headers contains "A, B... or Z"

    Hi, My name's Oliver and I'm currently writing my university thesis and need help with sorting out a lot of data. Have several worksheets, where every worksheet contains between 1000-7500 columns with headers and data below. I want to delete the columns that contain certain texts (like...
  9. P

    Copy rows with blank cell in specific column from multiple visible worksheets to one new table

    Hello everybody, I am trying to consolidate rows from tables on multiple worksheets into one table in new master worksheet. Tables have the same amount of columns from A to J but not same amount of rows. Condition for rows I want to consolidate to new table is the blank cell in column F. In...
  10. Aperras7

    VBA to split worksheet into multiple sheets. Based on rows. Keeping formatting and headers

    Hello all, I know that this question has been asked a thousand time before, but I can't find the perfect one for me. I'm looking for a VBA that takes all my rows and separate them into multiple sheets in the same document. Here's exactly what i'm looking for: - something that keeps my...
  11. E

    Opening multiple worksheets on the same workbook

    We're using MS Office 2013 and Windows 8. Every time we open a new excel file, it opens to a new workbook. It would be nice if we have the option to open a file on the same workbook (to easily put them side-by-side) or open it on a different workbook. We prefer to have the files look like this...
  12. J

    Running totals across multiple sheets

    Hello, I'm struggling with the formulas across multiple sheets. I'm presently trying to run about 10 worksheets on 1 excel save. I need to be able to keep running totals across these sheets. So for example, I need the total of Sheet 1 C47 + Sheet 2 C47 I then need the total of Sheet 1 C47...
  13. F

    shorter way to sum multiple Index/Match results from multiple tabs? Excel 2010

    Hey folks, this is a bit of an oddball question here. With much help from trolling this forum and others I've learned a lot, but often I just modify what I can find and make it do what I want :) I'm wondering though, if anyone has any opinion or advice on my formulas I'm going to post, because...
  14. L

    VBA Paste Formulas Across Worksheets to Last Row of Data

    Hi, I have a macro that splits my data by column x and pastes it into new worksheets for each unique item in column X. However, while the formatting is preserved I lose all the formulae. Is there a way of preserving the formulae while I do this? Or would I need to create a separate macro to...
  15. M

    Highlight Cells Across Different Worksheets

    Hi, I have three worksheets in a workbook all listing the same values, but in different sequences. I would like to highlight a cell/value on Sheet 1 and have that same value, wherever it appears, highlighted on the other cells. Essentially, these are working lists and when I switch back and...
  16. M

    Multiple worksheet and certain cells

    I have about 90 worksheets in a workbook that I want to copy 2 certain cells. The cell is different in each workbook depending on what the data is on each workbook. I know which row the cell I want to copy but not the column. Bascially I want to take the last cell in row 23 that has content in...
  17. T

    Need formula to retrieve data from a masterfile to a workbook with multiple worksshet

    I have two excel workbooks. One workbook contains one worksheet with all the data information. Another workbook containing 35 plus worksheets is what I need to populate. Let's say each worksheet pertains to each individual state (ie. California, Texas, etc.) in the US. The information I...
  18. R

    Search for text in name range in Sheet 1and return Value in Sheet 2

    Hi, I have something of the following : Shee 1 (Name Range : Code) Column A -------- Column B School ----------- 1 College ----------- 2 University--------- 3 Sheet 2 Cell A1 = (Search for "College" in Name Range Code and get the Value of "2" as code. ) So value of 2 should be present in...
  19. L

    Indirect fomula, multiple worksheets and sum function

    I have multiple workbooks containing a different number of worksheets with budgets in the exact same format. I would like to add a sheet (in the same format as all the sheets) in each book that sums up the other sheets in that book. In the sum-up sheet, however, I would like two cells to hold...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top