multiple worksheets

I am putting together a workbook that will track which employee's have worked with various clients during a given month, and which tasks they've performed for the clients. The workbook spans one calendar year. I want this workbook to be usable by anyone even if they have little excel...

hey guys, kinda got stumped here.. I have one worksheet that had suite #'s and dates worksheet #2 has an invoice date column where each suite has an id# and each charge shows a date. how would I separate the suite id# and dates... there could be more or less charges between each new suite...

Hello, I am very new to VBA and I am looking to create a macro to define the print area for each worksheet in my workbook. Currently this is the code I am using and it is assigned to a button; the trouble I have is that instead of setting the print area to the last cell of each worksheet (the...

Version: 2007 Hello Everyone, I have a workbook with a "Detail" and "Summary" worksheet. The data in each of these worksheets needs to be split up and grouped into separate tabs based on the value of a specific column (region). Then, the Summary and Detail worksheet for each region needs to be...

Hi, I'm trying to extract data from multiple worksheets from over 30 workbooks from a same path to a another master workbook. For instance, if cell D9 in the different worksheets is equal to "X", I want to extract data from specific cells for all those worksheets. I am very new to VBA and...

Hello, I have 23 worksheets (named 1, 2, . . . , 23) all based in the same template. In a summary worksheet, I'd like to do some summary analyses, e.g., medians of data from all of the 23 worksheets. To find the median of the values in column D of all of the sheets, I have found this array...

I realized that my original post was unclear, but could not find an "Edit" button for my previous post. Mods, can you delete the original thread? It has no comments. Thanks! First, I apologize for another auto-sort thread. I read through several of the various examples, and still wasn't...

Hello everyone, This is my first post so hi! I have no experience with macros so I'm hoping someone can help. I have a workbook with multiple (over 40) tabs and I need to sort all of the worksheets by the data in the first column on each sheet, ascending. I can make it happen on one sheet...

Guys, I have a userform (frmNavigation) with labels that I want to tally up the sheets based on the value of cell b6. This cell will always be one of three values (Cat Parts, Manufacturing, Imports) and I have 3 Labels (Label 9, label 10, label 11) that I would like to display these counts.

I have a spreadsheet and would like to create a list of the value in an absolute reference from multiple worksheets. Here is what the formulas for the final result might look like: ='Management Analyst'!B2 ='Human Resources'!B2 The spreadsheet is quite large (lots of worksheets), so the...

Hello, I am a novice when it comes to VBA - I can usually modify code that I find in forums such as these to get it to work for my circumstances, but I'm not great at creating my own. I'm hoping that someone can help me with a macro to split some data into separate worksheets based on page...

Hi all, I am struggling with a printing issue for a workbook with many sheets that I update & print on a weekly basis. Background - I am using Excel 2007, & pretty sure I'm working with a Windows 7 system. My workbook has many sheets, each with 4 graphs on them, which I have isolated on...

hi, I don't know how to explain, but I'll try :) I have 5 worksheets (each of them being 8 columns x 52 rows... if this matters) with the first worksheet aggregating (totaling, averaging, etc.) data from the other 4. Now, the secondary worksheets are fine and I can fiddle with them as I wish...

Hi all, I have a number of individual worksheets all in the same workbook that show current Projects and relevant Programme Managers depending on the Project Manager assigned to run the Project Rather than have a changing lookup via drop down etc I have been asked to have these sheets as...

I'll try to make this as straightforward as possible. Using Win7, Office2010. I have a spreadsheet with multiple worksheets (for different days) that lists the names of students and then a total amount due for each student next to those names for each day. The names in each spreadsheet are not...

Hi there I have a really confusing question , but I will try to make myself as clear as possible... So I have a registry Book, in which there are over 100 different worksheets, each asigned to a specific ''assay''. Each of them will have a cell called "Sample" next to which the sample number...

G'day folks, So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...

Hello! I am updating a payroll document that we use for the company that I work for. Right now, we have multiple documents that we "carry" numbers around to suit the needs of different departments. I would like a more efficient system where I only have to enter the numbers once, and they...

Hi Everyone, I'm trying to write a matching algorithm to compare text & number from two different worksheets. The first will have one row of information, which I have stored in a dictionary object, and the second will have many rows, which I will look through with the for loops. If all the...

Hi there, I have written a macro for a specific workbook to apply to multiple worksheets, I have about 30 other workbooks to apply this to and the sheet numbers will be different in each work book. All sheets that need to be formatted contain the word "plot" in the name. How do I set a variable...