multiple tabs

  1. G

    VBA: Use loops to copy a groups of worksheets into multiple workbooks

    Hello, I created a macro that uses a counter to create 3 worksheets for each country included in a data tab. The data tab can have a variable number of countries, so the macro counts the number of countries and creates a Cover Sheet, Expense Sheet, and Income Sheet for each country (e.g. the...
  2. C

    Sumif across multiple tabs

    I want to create a working document which will compare sales data LFL Multiple sets of data needs to be imported on a weekly basis on separate tabs, i.e WK01, WK02, WK01LY, WK02LY, etc. The layout of these sheets will always be identical. Rather than having to repeat formula's 52 times on...
  3. N

    Sumif over multiple tabs and rows

    Help please..... I have a workbook that has say 100nr tabs Each tab has a row that under Column A will have the wording "Total Hrs". From column B onwards (working towards the right) will be the sum of these hours, so B will have a total, C will have a total and so on. Problem - the "row"...
  4. K

    VBA to send Access tables to individual worksheets in Excel...

    Hi all, I was wondering if there was some VBA code that could be used to send tables from Access to multiple tabs to an existing Excel document? Or create a new document. I suppose either would work. Please and thank you. Also posted in Excel forum here...
  5. A

    Find match through multiple workbooks and tabs and copy a cell's value to a another one

    Hello everyone, I was searching through the forum for a solution on using Index/Match but I didn't manage to find one solving my problem. I have two excel documents. The one of them contains information about participants of a quiz. Each week I have to retrieve the participants of the quiz and...
  6. M

    Macro to Import Multiple CSV files into specific Excel tabs

    Hello, I have a project that I'm hoping to get help with. I need to import multiple CSV files into specific Macro Enabled Workbook that already has uniquely named Worksheet tabs. I have code to do this for 1 CSV file into 1 worksheet tab. However I have 7 CSV files (always the same CSV file...
  7. G

    Existing Pivot Table need to extract data from multiple tabs

    Hi Excel Gurus I currently have an existing Pivot table. I have been looking on line to find a way to have the existing pivot table to look into multiple tabs. I already have the tabs named. The only thing I found at this point is how to create one from scratch. However, I don't want to do it...
  8. R

    VBA to convert three tabs to csv and add to email attachment

    This is a big ask, but could anyone please help me find a macro to accomplish the following task? I have a workbook that has 3 tabs with information to be uploaded in a 3rd party software. They will need to be uploaded into csv format and need to be save for records. I would like to use...
  9. E

    Need help with Excel to link cells across multiple tabs?

    Hi, I need to link cells over multiple sheets but they must be allocated to a specific sheet according to certain criteria. So in Sheet1 <Renamed to 'General'> I have Columns : A(Farm Code) B(Inc/Exp code) C(Description) etc etc. Row example 1 101 Milk Income etc etc Now in...
  10. N

    How to replace several old values with new values on multiple tabs?

    I have a bit more than hundred tabs and want to clean the data on those tabs. Some values are written in multiple ways. If I do not want to find & replace all old values one by one on all tabs, how can I find old value and replace them with new values at once, if I create a new tab with old...
  11. A

    Combining multiple excel sheets from multiple workbooks into one table

    Hello, I have 12 excel 2010 workbooks with 6 tabs each that I need to combine into one table using either PowerQuery or PowerPivot. I could do it manually, but that would take a few hours and it's not really efficient, so I have been trying to figure out a way to do it using one of the BI tools...
  12. T

    efficient code to move group of cells from one tab to another

    hey guys, I have a tab that has main info. The tab has the code below to filter out and create new sheets based on a word. I am trying to get certain cells from the output to be placed in corresponding cells within other tabs instead of random sheets. how can I have the data go from the main...
  13. T

    Loop through column extract data paste to matching tab

    I have 4 tabs of different #'s 201, 202, 203, 204 In a master tab I am dumping data... I have a suite column that has suite #'s and dates Each of the 4 suites and their dates are in this master data list. I am trying to get a macro that will loop through column and insert each suite and its...
  14. B

    VBA IF Loop Help

    I'm having a bit of trouble with a macro. The code is supposed to first check to see if a certain parameter called 'Setup' is True or False and then checks each sheet for the value of R43 if 'Setup' is True or R44 if 'Setup' is False. If the value in R43 or R44 is True the code highlights a cell...
  15. B

    Sum across multiple sheets with 2 way look up

    I am looking for a way to populate a summary table. I export multiple sources of data, which all have the same information but arranged in a different way. The constant would be the date that I keep on the far left. So what I am looking for is a way to use the date then look up the column...
  16. L

    VBA - Hiding and Unhiding numerous rows based on numerous cells

    Hi, I'm new to VBA and Macros so apologies for that! What I have managed to achieve so far based on online forums and guides, is to hide or unhide a column and 'rows in a different sheet' based on a data validation selection in a cell. Example: <tbody> Stages Yes or No Stage 1 Yes Stage...
  17. B

    copy and paste multiple ranges from multiple tabs in old wkbk to new addresses in multiple tabs in new wkbk

    I have a multi tab template which has been significantly revised. I need to migrate the data from about 500 files of the old template to the new one. This would involve copying and pasting multiple ranges from multiple tabs in old workbook to multiple tabs in the new workbook. (probably about...
  18. derek.hughes

    Macro to sort across multiple sheets and remove duplicates

    I have a workbook with multiple sheets of data and all are in the same format (data with the same headers in columns A:I). However, the number of rows with data is a variable - different for each sheet. I want it to sort column A ascending and column I descending, and then remove duplicates -...
  19. L

    Create PDF with data from specific columns in multiple tabs

    Hi all, I am currently working in a spreadsheet with multible tabs, where the format is the same: a table where values (text) from column 5-row 3 (and down), column 6-row 3 (and down) and column 7-row 3 (and down) should be transferred into a PDF with a table consisting of the three columns...
  20. M

    Index plus match with multiple tabs

    Hi there, Below is a formula I’m working on. I want, if possible, for excel to look in tabs "acctg" through "RM finish Bundling" for the text that i have in '2015 Consolidated!A96'. The formula works if i only use one tab, but if I could have it look through all those tabs, it would help me...

Some videos you may like

This Week's Hot Topics

Top