multiple worksheets

Hello helpful peeps! Here is what I have: Workbook1 = Consolidation Sheet1 = Annuity Sheet2 = Annuity Adj (will be hidden) Workbook2 = Variable Name Sheet1 = Remit (Variable rows) Sheet2 = Adjust (Variable rows) I have current code that sets up the Annuity and Annuity Adj worksheets in the...

Hi, I am using a formula as follows to pull out the rightmost result in the second row in the column range F to Z: =LOOKUP(2,1/('ABC1'!F2:Z2<>""),'ABC1'!F2:Z2) This works as expected, but I have a number of worksheets, and I'm looking to pull out the rightmost result in the second row in the...

Hi, I am working with making a template in excel for writing hours at my workplace. In sheet one named “Oppsumering” I want to have a summary from the other sheets I add. Each sheet represents one week and contains the hours from different tasks. The sheet named “Uke—” is the layout for where...

I have a summary page with people's names and I am summing up their sales from a given month (worksheet Jan, Feb, Mar, etc.). In those months there are one or more sales recorded in a row. But for some reason starting in the month of May and only on a few select people it no longer gives a sum...

I have a number of excel files that have two different named sheets (let's call them "x" and "y" for simplicity); so file1 has two sheets "x" and "y"; file2 has two sheets also named "x" and "y". I want to combine all of the worksheets named "x" onto a master file with a similar name such as "x"...

I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...

Hello all this is my first post and also learning vba. I was hoping to get some help solving this issue. I am trying to copy and paste rows with a true value of "open" in column A to a specified worksheet("Open Disc") from all available worksheets. When pasting all true values, I would like...

Hi, I have an excel workbook with 200+sheets of data tables. I need to create a named range for each table. That is for each table, I go in and highlight a range - say A22:S50 and then name it Table1, Table2 in the name box or I can do this for name manager. Is there a way to automate this...

I have a document with worksheets named WK01 to WK52. Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change. In column E of the week worksheets there will be a name of a product, column F the...

Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...

Hello - I've searched the forum, but not found anything that specifically addresses my issue. I have a task list workbook that contains 4 sheets: Master, Today, Assigned and Done. All tasks are entered in Master, and I want to have the row deleted from Master and moved to the next available...

Hi, I am working on a project and I am trying to import data fromone excel workbook (possibly converted to a .txt file) to another and wouldlike to use vba to do it. The data imported to the second excel workbook wouldneed to be inputted on various worksheets and various cells, which are not...

I have tried searching through the forums to hopefully find an answer before posting, but I could not find anything. So please direct me to another thread if I simply failed to find it. Sheet1 This sheet has data in cells B3 – B52 Ex. B3 = 750 E B4 = 750 F … B42 = 610 B … B52 = (Blank, Future...

Hi Guys I have two worksheets with customer data in them, I had created a pivot table for one of the sheets and then was doing a =COUNTIF(TCF!C:C,"*"&A22&"*") to match the data on the other worksheet it would provide a 1 if it was there and 0 if not.:eeek: Is there a simple way around this, I...

I'm working on a workbook to collect several individual worksheets worth of data into two main worksheets. The data is always changing and the amount of populated rows changes as well. What I need: Delete all rows under row 5 (starting at row 6) in worksheet "Active - TOTAL" Delete all rows...

I have a multiple sheet workbook that has 7 dates on a row with values listed under those dates in up to 7 rows. I also have a collection sheet with a moth of dates in a column. I want to search all 53 sheets for a date on the collection worksheet. When a date is found, I need to copy the data...

I have a project that has a dropdown list for user selection based on the item selected, I want to be able to write user data to a different tab of the destination workbook. For example if user selects "Banana" from the list I want the submit button to go to "Workbook2" then set Worksheet to...

Hello, First, all of you have been a huge help over the years. This is my first time posting, so I hope this is not incorrect in any manner. I appreciate any assistance. I am creating a VBA automation step for peers that have to manually enter in contract information for each of our...

Hi All, Is there anyway with excel to compile loads of data from multiple work sheets into one worksheet? I have loads of worksheets that have the exact same layout on each one. I then want a way to pull each work sheet to a new row on one worksheet. Can anyone help me with this please? Nathan

Have a workbook with 70 different worksheets, all the worksheets are the same "Form", all these forms have a "comments" section (cells A35:G36), and a cell F32 which if an X is placed in it, indicates a failed inspection. Trying to add a table to the main page in essence a summary of failed...