sheet4

  1. P

    match and update vba code

    Hi hope you can help with vba code ease as i am completely stuck. :) On sheet1 I have 2 comboboxes named ‘name1 and name2’, incell C10 this is where the date (dd/mm/yyyy) is inputted in this formatmanually as this needs to match what is in sheet4 which is the calendar. I also have a...
  2. S

    Get sum of the values in corresponding cells.

    Hi, I have values, which changes each day, in range (T12:AA21) in 32 identical sheets viz sheet4, sheet5, sheet6, sheet7 etc. Sheet4 is a "Summary sheet". I want in sheet4 range (T12:AA21) the sum of the values in corresponding cells. Like Sheet4.range("T11").value=...
  3. F

    Pass array of sheet names to another procedure

    In lieu of placing the array of sheets within the two procedures below, how can I use a third procedure to establish the array of sheets and then pass that argument? Sub ApplyAutofilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets(Array("Sheet1", "Sheet2", "Sheet3"...
  4. H

    Copy Data if item does not exist on another sheet

    I Have a list of items in Col A on sheet4 I need a macro to the items on sheet4 in Col A after the last row in Col A on Sheet5 if these items do not exist in Col A on Sheet5 For eg is Ste01 is in Col A on Sheet4 and exists in Col A on Sheet5 then do NOT copy. If MTT001 is in Col A on sheet4...
  5. T

    SO Close and yet so far. Simple answer Im sure.

    Hello, i have a book full of item numbers for an ecommerce site. The template requires me to segregate the upload data. I need to Index RAW DATA on sheet10 and place into Sheet4. Step 1 is to find the matching Item# (Key data) and then read across that entire row to find the matching attribute...
  6. kelly mort

    User defined function to store conditional Vlookup formula needed

    I have 3 sheets that I am using Vlookup formula to pull data from based on a condition in a cell; A2 on Sheet4. And the conditions are A, B, C. If A, then I am looking up the value in B2 on Sheet4 from sheet1 range A2:D30 . If B then same value in B2 Sheet4 but now on sheet2 in that order...
  7. A

    Help with VBA macro

    Hello everyone! First of all I have to say is a great forum! found really interesting stuff that helped me with my VBA skills. Secondly, I was wondering if someone could help me with a simple macro that I couldn't find online and is driving me crazy. What I have is a table with different...
  8. S

    Puzzled by a VLOOKUP formula

    Hi, I have this formula: =IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"") which works absolutely perfectly. I then created a new page & using the same formula but tweaked a bit changed it to this...
  9. H

    Lookup row and match against column

    Hi all, hope anyone can help. In Sheet4 D2:AJ2, I have I have a list of values of which some are blank. In Sheet3 G2:G132 I have potentially one of the values in the array for Sheet4 D2:AJ2. In AL2 I am trying to match the array in Sheet4 D2:AJ2 against the array in Sheet3 G2:G132 and give me...
  10. sharky12345

    Advanced filter, unique values with criteria

    Can someone show me how to adapt this code so that it only copies unique values where the cell in column C matches the value of Sheet4 E2? LastRow = Sheet7.Cells(Rows.Count, "A").End(xlUp).Row Sheet7.Range("D3:D" & LastRow).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheet4.Range("E4")...
  11. G

    If statements

    Good morning, I would like to know how to write an IF statement that is capable to do the following: =IF(C3:I8)(Sheet1) contains "5229" then copy A3 of same row(Sheet1) and paste to (Sheet4) B2 Any ideas? ;)
  12. jluangrath88

    VBA to Extract Unique Values/Rows Across Multiple Sheets into One Sheet

    Hi Experts! Here's my current situation. And I would very much appreciate the help :) I have 4 different worksheets. Let's call them: Sheet1, Sheet2, Sheet3, and Sheet4. The first 3 contains data that is delivered daily. Sheet4 is meant to dump the raw and compiled data between the first...
  13. Y

    Sum every 7 rows in another sheet and paste result

    Hello all, I have a very urgent situation, if you can help me: - I need a vba to look in sheet4, make the sum between every 7 days (c2:c8), and copy the result in sheet1 H7, then go again to sheet4, make the sum between next 7 days (c9:c15) and copy the result in sheet1 h8, and so on for every...
  14. J

    Help needed, Workbook needs repair on every open

    Hi, appreciate any help with this: every time i open i get this: The workbook and all macros work fine, but after saving and closing, when i reopen i get same error I dont have a sheet4 any way to remove this error permanently? thanks
  15. D

    Run multiple subroutines to completion with one button click

    This is kind of complicated, so let me see if I can do it justice with an explanation that doesn't take 10 pages. I am working on a scheduling workbook for another department at our firm. They use it to keep track of what everyone in that department is projected to work on over the course of...
  16. H

    vba code/formula to retrieve common entries across columns

    Hi, I have for example 3 columns Column A Column B Column C SHEET1 SHEET2 SHEET3 SHEET2 SHEET3 SHEET4 SHEET3 SHEET4 SHEET4 I want the common entries amongst the 3 columns in a new column. The output should be Column D Sheet3 Sheet4 any help on this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top