req

Hello All, Info: I've created a spreadsheet that filter data from and inventory list to 2 other sheets one titled "low" and the other titled "out of service" when the "actual qty" falls bellow the "req qty" in the inventory list it's filtered to the "low" sheet. When the "req qty" turns to...

I need to create code to search column "C" for any cells that contain "REQ", and then insert the text "REQ" in the same row in Column "Y". My code is not working and any help would be appreciated! If ActiveCell.Value == REQ" Then ActiveCell.offset(0,25).Value = "REQ" End If

My Excel workbook has 4 main tabs, AM – Asset Mgmt, MM – Materials Mgmt, WM – Work Mgmt, and Add’l Req. Each tab has a header (Row 1) that is formatted the same across each sheet except for color. Each column is formatted with the same width across each sheet. Column C on each sheet is labelled...

I'd like to use Index/Match or something similar to fix how a report runs for me. I have duplicate data in columns (req number) but unique data associated with it (Approver). How would I accomplish this so I can have each approver in a separate column. I've tried to transpose, but it doesn't...

Looking for some help, think I need to use a multiple criteria Index & Match. I've done it before but can't get it to work this time. Below is some dummy data <tbody> A B C D E Req ID Job Title Region Candidate Name Start Date 1234 Jobby Job NE AC Slater 1/2/2018 1234 Jobby Job SW Zach...

Hi Please can someone help me. I have a whole list of serial numbers (H001 to H4569) which I want to find within a multiple text strings. Example: H2365 ATTEND TO NOT STARTING 384146 REQ, but the serial numbers are either in the beginning, middle or end of the text string. But the formula also...

Hi guys i'm still working on different web puller scripts. So I just created a little web puller code here, The plan was to just make it with an visable IE to see that everything is working then make an XML req of it. Problem however is that there are some expandable rows that needs to be...

Looking to return staterate and localrate from xml response to cells A1 and A2 in active WS I will modify later so that street address, city, and zip can be in three other cells in the sheet so the commandbutton1 can query for tax rate when clicked. This is what I have so far: Private Sub...