multiple sheet

  1. U

    VBA Create a Copy of Sheet Multiple Times

    Hi Guys, I was wondering if you could help me on this. I have this Sheet with tab name "All Region" which is a formatted list. I want to create 8 copies onto the same workbook and just rename it as follows: 1. Germany 2. France 3. UK 4. US 5. Ireland 6. Canada 7. Other EU 8. Asia Any help...
  2. E

    Update Cells from Certain Tabs based on Value other cells

    I have a workbook with 1 tab per calendar day for basic Hotel/guest management system. Each tab has a table to manage daily check in / check out info & payments made by customers. I want to be able to have a formula on each tab that recognizes the check in & check out date and: 1) Updates all...
  3. M

    Create a chart with data from multiple sheets

    Hello, I am new at VBA and I definetly need some help. I am trying to create a XY graph with data from multiple sheets. All the sheets have the same structure and different names. The number of sheets can vary from one file to another. I recorded the macro of what I need but it is only working...
  4. P

    Copy single column from different sheets and paste it in master sheet side by side

    I have a workbook that has 500+ sheets naming sheet1, sheet 2,sheet3......sheet500...each sheet has multiple columns. I need to copy 'M column' of each sheet and paste it in a master sheet. like from sheet1.. O column in master sheet in A Column, from sheet2 ..O column in master sheet in B...
  5. I

    Copying data across multiple sheets

    I've been looking for an answer to this but haven't found it yet, so I apologize if this exists somewhere already. I'm trying to make a database of multiple workgroups (1 per tab) and have a combined tab that copies all of the information (based on the individuals name) over. The formula I have...
  6. G

    Formula to Align identical Cells/strings which are present on different sheets

    Hi, I have an issue whereby i have 5 different sheets of information Each sheet signifies a different category. Each sheet contains two columns. One with a code and the other with the value of that code in that particular category. Example; Sheet 1: <tbody> Open 71224 $20.00 71848...
  7. D

    Print multiple sheets to PDF, Email as attachment

    Hi, I've looked at many different codes and can't get any of them to work for my particular situation. I'm too new to VBA to understand how to combine the ones I can find. I would like to print 2 sheets (Client Letter, Client Breakdown) to PDF. File name to be contents of cell A1 save to...
  8. S

    Conditional formatting between two worksheets

    Hi - I have a large spreadsheet with multiple tabs in it. I'm looking for a conditional formatting solution for the following - I'll explain: Say in my worksheet I have Tab1 and Tab2. Tab1 has a list of customers we work with based on submissions they send in. on Tab2, I keep track of these...
  9. N

    Ranking across multiple excel sheets

    Hi all, I was wondering if you could help. I have sixteen worksheets all player names (ie John, David, Joanna, Laura) each sheet uses the same template of tests in column A and the Score in column B. I would like to rank each players score for that specific test in column C . Ie 1600m...
  10. T

    Sending out multiple emails from multiple sheets in a single workbook based on listed dates.

    I’ve seen several threads and videos addressing how to use a macro to send an email from excel using outlook. All good there. However, I’ve got a significantly more difficult task to try to accomplish. I’m trying to get a button added to my first sheet in the workbook that will search each...
  11. D

    Copying multiple workbooks to multiple workbooks

    I have hundreds of workbook that contain data that have to be pasted onto respective workbooks and I wrote 4 modules. Sub AllFiles() Dim folderPath As String Dim filename As String Dim wb As Workbook folderPath = "C:\Users\HKIEd\Downloads" 'change to suit If...
  12. S

    VBA Copy Paste Multiple Sheet to one Master Sheet

    Hello Everyone, I would like to ask an assistance, I am new in scripting VBA and I need help on how I can transfer all the data from multiple sheets to one Master sheet in the Excel File. I have 6 Sheets where I'll get the data and the data are in Range A7:K16 (this range applies to all the...
  13. R

    Import data from workbooks, convert them and paste it in "main" Workbook

    Hello MrExcel forumers and experts, For sometime now I'm facing this problem I have and I'm hoping that you guys can help me solve it. I've tried using the advanced search but none really solve the exact issue I'm having. Here it goes: I need help extracting and editing data from several...
  14. P

    How to format/modify data in clones of a sheet through vba?

    Assume I am having some clones of a sheet (copies of a sheet). How to work with those clones (format/modify data) at a single time? (through vba). What is the default way of doing it? and Is there a way to do it without working with the selection (suggested by the record macro). Thanks in...
  15. G

    Need to Count Text Entries Across Multiple Sheet That Correspond With Criteria in the Same Row

    Hello, This is Military Spreadsheet that involves troop movement so I have to be very vague but I'll try not to be confusing. Here's a problem I'm having. I need to count how many times text (any text/numbers/combination of the two) appear in a column across multiple sheets. Here's the...
  16. X

    Looking up values using multiple conditions

    Hello everyone, I am trying to compile an audit sheet in which I am collating individual spreadsheets from different auditors in a pre-defined format. The "Main" tab in my attachment shows how I want the final output to look like, and the "Audit Sheet" tab contains the data that will be provided...
  17. S

    Multiple macros specific to a worksheet in one workbook

    Hello, I am a complete newbie to vba and learning it on my own. I am trying to automate a very tedious process of monthly reporting using excel. The code below is what I have got using the Record Macro function and tweaking it quite a bit to suit my needs. I need to run a similar macro on...
  18. M

    Pivot table from multiple sheets

    Hello, Can someone help me to sort out myproblem, please? I created pivot tab;e from 10 sheets (all formatted exactly the same), however the pivot table field only contains row, column and value even though it has 17 column headers that I need to do analysis. Is it usual or am have I...
  19. M

    Last updated Macro.

    I would like to have a macro which displays in one spreadsheet when sections of other worksheets were updated. So for example in sheet A in cell B4 I would like it display when any cells in between A3:10 and C3:10 in sheet C were last changed, in Sheet A cell B5 I would like it to display when...
  20. D

    Macro To Replicate Chart on All Sheets of Workbook

    Here's my challenge: I have 100 sheets in my workbook that are all identical in layout but contain unique information within each sheet, all based on the same parameters. I've got cells in B14:B18 that contain label information (Earnings by Outlet) and cells in F14:18 that contain numeric...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top