sheet4

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...

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=...

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"...

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...

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...

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...

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...

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...

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...

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")...

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? ;)

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...

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...

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

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...

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...