different sheets

  1. D

    Formula to Check Matches

    I thought this would be simple however, I am finding more difficult than I originally thought. I'll try and keep it simple. I have a single workbook with multiple sheets with data. I am needing a formula to check column A on sheet #1 to columns A,B, and C on sheets #2 and #3 . If the numbers...
  2. D

    Pivot Error showing but on a different macro Sheet. Not on the sheet the where I refreshed

    Hi, This is my first time. I have been looking everywhere for a solution for this I have made a pivot table on Sheet4 and named the Pivot table to Overtime. But when I refresh manually by right click the newly made pivot table stops and shows an error ------------------ Run-time Error '1004'...
  3. D

    Emailing sheets different emails.

    Hi All, I am trying to do an automation of an excel emailing process. I have a workbook which as around 68 sheets in it. I have to send the sheets as attachments to multiple email IDs. The Email ID are in the A1 cell in each sheet. There are some sheets which needs to be sent to one email ID...
  4. Q

    Index and Match across different sheets

    Hello, I have a 2 D data (rows and columns) on Sheet 1 and I have specific values in Sheet 2. I want my index match formula to return select from the range in Sheet 1 and the rows and columns in Sheet 2 to return the value specific to that combination. =INDEX('Zone & Pricing...
  5. S

    copy cells to another sheet based on cell criteria

    I am trying to move cells between cols A and L to a sheet named BREAK from a sheet name FAB w/ the criteria being met "Single Rollup Frame" in col B and it being a copy/paste that will always paste on the next available row. The code I have works some and doesn't give a debug - but it is only...
  6. C

    Slowest Macro ever - Please Help! Copy Paste

    I have written this over and over again. Its takes 30 seconds. I am a novice doing this a few months. I should be defining...tried that but could not get this to speed up. It works but looks embarrassing, I am aware. After a couple of days of trying to speed it up, I am turning to the Guru's...
  7. S

    Insert Row in excel table based on text input in a cell

    Hi All, I need a VBA code to insert a new row in my excel table if any text is inserted in a designated cell. My excel table is in a sheet with name "Reference #" and the new row should be inserted in Row 7 of this sheet. The designated cell is in sheet "Data" with cell reference B2:D2 (Cells...
  8. G

    Combining two codes for two different sheets into a mastercode on a separate sheet

    So I have two codes that I am using to delete cells from two different sheets. I first had a button on each sheet to run the macros, but instead I would like to create one button on my third sheet that will run both macros. My first code is for Worksheet ("yard") Sub RemoveTractors()...
  9. J

    Copy a column based on a cell and paste to another sheet in next open column

    Hello, I would like to copy a specific column from sheet1 to the next open column in sheet2. So I would like to say take cell A1 and find that in row 1 of sheet1 and copy that specific column to sheet2. In addition it is copying a value with a formula behind it when I paste it I would like it...
  10. D

    Index function problems when multiple tables/area numbers are on different sheets

    I want to use the reference form of the Index function where there are different lookup tables/area numbers but where one of the tables is on a different sheet. I have a simplified example where this works no problem when the areas are on the same sheet but doesn't work if one of the areas is...
  11. B

    VBA - Compare Two Lists on seperate sheets

    Hello everyone! :) Thank you for all the great solutions I could copy/paste from here to use for my own projects. Unfortunately I do now have a rather simple task, which I can figure out to work. I've tried several attempts, but did not get a satisfying result. The situation is the following: I...
  12. L

    Loading several .txt files into different sheets of an .xls

    Hello everyone, I´m trying to analyze several measurements in one excel Worksheet. Attached you find the xls sheet and a picture showing the folder structure where the measurement data is stored. https://www.dropbox.com/s/7dvmtv458cpumb4/Capture.JPG?dl=0...
  13. J

    Run macro from button on separate sheet

    Hi guys, Brand new member and first post, this is also my first time playing with macros/vba and have searched the web for two days now and have come up empty handed; I hope you can help. I have a workbook (Master Production Report) where I have the following tabs Tab 1 "Control": Here I want...
  14. P

    Print dynamic ranges each from different sheets in 1 go ?

    Hi Trying to Print dynamic ranges from different sheets in one print run. I have the code below but I cant see why I doesn't populate, and I get an object error. Guidance always appreciated Sub PrintAllDataSheets() ' Print Initiate Investigate Validate Audit Implement Summary Page in sigle...
  15. M

    Running a macro when double clicking a cell in another sheet

    Dears, Good morning or good evening wherever you are. I am new with VBA. So, I had to search online on how to do what I wanted to do with my workbook. But now I am stuck and I hope you could help me. In sheet 1, there is a table of data. Each row has a site code and some data related to this...
  16. D

    Update different sheets . VBA

    I'm new to all VBA concepts so I really need help. I have a file with 3 sheets. The first one contains clients from the UK and FR (this being column 3) , the second one clients only from the UK and the third one clients only from FR. I want a code that will update the second and third sheet once...
  17. J

    AVERAGE data from 3 sheets

    Hi, All, I see that this is quite simple but I am not able to get the formula. I am trying to average 3 sets of data from 3 different worksheets with a criteria to follow. I am using Excel 2010. Worksheets contain scores on a daily basis. Example: Sheet 1: Jan1-50%, Jan3-65% Sheet 2: Jan...
  18. R

    Excel 2010 / automatically update table column in another sheet

    Hi, This seems fairly easy, but I haven't had much luck with searching for the answer on the web. I have an Excel 2010 table in Sheet 1 (FYI, table has headers with 11 columns). In Sheet 2, I would like to continually reference a particular column (Column 1) and its rows from the table in Sheet...
  19. N

    Comparing two columns on different sheets (no case-sensitive/no space sensitive)

    Hello everyone! I rely on your expertise for this! I need to compare two columns on different sheets and get all the non-duplicates on a third sheet. I would like the results on the third sheet to be red-highlitened and to show the the same row content present on the first sheet. The...
  20. N

    Macro to compare three columns on different sheets. Please help!

    Hi eveyone! What I really need is a Macro that can compare three columns of data each on a different sheet. Excel 2010. Here is step by step what it should do: 1) Take columnB on sheet1 and compare it with columnA of sheet2 and columnA of sheet3. 2) The result of this comparison should fill...

Some videos you may like

This Week's Hot Topics

Top