multiple worksheets

Hello, I have a working VLOOKUP formula for generating a one page inventory list. It grabs values from worksheets in other spreadsheets. The only problem is it doesn't automatically update. Please, someone help me! Thanks in advance, Drowning in Quicksand

Hello everyone I am a bit stuck on my current project and after searching these forums I got encouraged to post my question. Lets say I have some Workbooks saved in a specific path (C:\Workbooks). Each Workbook has a different name and within each Workbook there is a Sheet called "Final...

I'm trying to figure out some approximate space requirements on a disc based on output from some Powershell scripts whose output data I have imported into Excel. The file structure is similar to this: z:\MyData\MyFolder\X1 z:\MyData\MyFolder\X2 z:\MyData\MyFolder\Images z:\MyData\YourFolder\A1...

Hi all :) I have a dataset with 34 columns and ~5000 rows. In column G there is an index number. The index number goes down the column, increasing by 1 each time, eg in G2 the index is 1, in G3 the index is 2, in G4 the index is 3. . . Data worksheet <tbody> Columns A, B, C, D, E, F G -...

Hi there!</SPAN> I have a large amount of data that is all contained in a single worksheet. I am trying to create a macro to separate the data according to name in Column A, then place each block of data with a different name in column A in a separate worksheet in the same workbook. For example...

Hello. Could someone please help me with my spreadsheet? I want it to do 2 things; 1 of which I have managed but now I have an error re my drop down lists. 1. I have a main worksheet, where I enter and update rows. Depending on the answer in Column N, all of the corresponding data in that row...

I have a workbook with multiple worksheets. I want to print the entire workbook and have the page numbering of each worksheet read "page 1 of total number of pages per worksheet" (not the entire workbook); e.g. if worksheet 1 has 23 pages the page numbering will read page 1 of 23, page 2 of 23...

Hi guys, I need a formula which will do the following: =AVERAGEIF(O6:O1721,">1",O6:O1721) but over several tabs, all the tabs are identical. Many thanks

how can i do =AVERAGEIF(AZ6:AZ1721,">0",AZ6:AZ1721) but across 18 tabs all with the same ranges???:laugh:

Hi, First of all - thank you for being willing to look at my issue. I have a workbook with over 50 worksheets (tabs). Now scrolling between these worksheets to find the correct one is tedious and unpractical. Is there a way to make some kind of scroll menu on the first worksheet that shows...

Having surched the web and other sites for two days i desperatly need some help. Let me explain. How do i get a macro/vba to look at a list of sheets in one worksheet and depending on the data to the right of the name clear the correct range(s). for example list would look like staff M5...

Hello Please can you help urgently....? I need to send out hundreds of spreadsheets to individual people within my company, and would usually do this by pivoting the data, splitting this out into separate worksheets (by manager name), and then using a macro to split the worksheets into separate...

Hi all, I have a file with ten worksheets which have data groups in the same position on each sheet. I'd like to expand and collapse them on all sheets by using grouped sheets but it seems this isn't possible when clicking the + or - box, or clicking on the 1, 2, 3 etc boxes in the top left...

Hello, I trying to figure out a formula in Worksheet 1 that will compare the holdings in Worksheet 2 to the restrictions in Worksheet 3. I've included a table below, but please note the following: The restrictions are identified by the sedol. The XYZ Weight in Worksheet 2 indicates the...

Hello All, I'm trying to build a Macro that will automate the process of pulling information from another workbook. Say "August Accounts" from "August Returns". The information is always in the same place, however, each month, when the new books come out, I don't want through the code line by...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi there! So I am in a bit of a bind and need help figuring out the following: I have 23 Worksheets. All of the worksheets have the same headers in the same column locations All of the worksheets have different criteria (names, dates, blank fields, etc.) Worksheet 1 Col A - Building...

Hi, I'm writing a VBA code: There are 10 members who are either Male or Female. "Males" and "Females" are two different worksheets with data on them. Dim ELT As Variant 'If "M" is on the sheet, refer to "Males" worksheet else "F" for "Females" worksheet. If ActiveCell.Offset(0,2).Value =...

I hesitate to ask the question because I'm not sure if it's appropriate for this forum or resource. If it's not please let me know! Any info is GREATLY appreciated. I have information in Worksheet Alpha. I have similar information in Worksheet Beta. I need to find rows in Worksheet Beta...