criteria based

Hi everyone, Background: <tbody> A B C D Policy Issue Service Benefits Application Service Request Analysis underwriting Policy Accounts Payout Payment Admin </tbody> <tbody> </tbody> The Blue text in Column A is level 1 data; the red text in B,C and D column is Level 2 data...

Hey Guys, I've been trying to figure this out but could really use some help. I have an output file from a machine that comes in a long list in column A. I'm trying to write a vba macro that goes through the list and moves a varying length section (based on header) to the next available row...

I am using code to transfer data that don't have a blank cell in column A from "Data" to "ForIndustry". While the code works, I would like to only transfer columns A:P rather than the whole row. Any guidance would be much appreciated. Sub transfer() Set i = Sheets("Data") Set e =...

Hello, I'm learning Excel VBA and I would appreciate help. I'm trying to highlight a row of data in one workbook (Table 1) if criteria in column A matches criteria in column A of another workbook. I need help referencing the other workbook without naming it explicitly, the...

Just curious if a string of data can be returned if a set of criteria is met: Here is where I am going with this. <tbody> A B C D 1 123 Main Street Las Vegas, NV 88888 Criteria 456 My Avenue Miami, Florida 55555 2 456 My Avenue Miami, Florida 55555 Avenue 3 789 Their Boulevard...

Hi! I’m trying to find a simple solution for my Excel VBA script. Sorry for my bad English in advance..:) There is an excerpt from my code. Sub TEST() Range("E2").Value = Application.WorksheetFunction.CountIfs(Range("G4:G1000"), 100, Range("J4:J1000"), ">0") End Sub It puts (in E2 cell) an...

Hello All, I am looking for an easy solution to a rather tedious formula. Here's the situation... I have a list of data that I would like to SUMIFS. From that SUMIFS, I would like to subtract out values that meet certain criteria in another, separate range. Lets use an example to help better...

Hello, I am looking to derive a value based on a variable data set. I want take the date that is chosen and find that value in Column C then look to Column E's # that is chosen and give me the value from Column C that is that # (in this case 1) day prior to the Date I entered. Another kicker is...

My setup: (2 Workbooks) Workbook 1 "Line Audit Workbook", Workbook 2 "Data" Workbook 1 has 2 worksheets - "1st Shift" and "2nd Shift" Workbook 2 has 1 worksheet - "Data". In workbook 1, both worksheets are set up identically with 13 columns. Each shift (1st Shift and 2nd Shift) gets information...

Hi all, I'm working on a macro, which looks up a date in an excelsheet with up to 30000 rows. Each row contains date values (column C) and temperature values (column E). I have about 250 rows per day and I would like to return the minimum, maximum and average temperature for each day. I tried...

Hi Guys, help! I'm trying to select ranges dependant on certain criteria <tbody> model Partno. pass /fail qty fail serno (fails ) root cause </tbody> model , partno & pass/fail , qty fail will be common throughout. data will be entered sequentially. I would like to to reserve a range serno...

Hi, I'm trying to create a macro that hides any columns that do not contain any numbers. for example: <tbody> Cat dog mouse 3 mouse 5 mouse 4 Fred x x x x x x x x x x x x x </tbody> Turns to: <tbody> mouse 3 mouse 5 mouse 4 x x x x x x x x x...

Hi, I have a master spreadsheet that needs to pull information from a report (SHE Mand Courses 25Jul14) I have an employee list with columns for various courses in my master sheet. I have a report from which I want to pull the end date when the course was completed and otherwise the cells...

Hello. I have two tables with similar information. File A is the raw, and File B with selected items. Is it possible to return all code under title “DEF” from File A in the way ”A112, A144, A134, A136, A452, A584, A714, A848, A980, A988” to file B cell B3 with title name(A3) and date range...

Hi, I'm new so be gentle. This is a bit complex for me so I'm completely lost. Below is an example of what I receive from our system, except imagine it about 200 columns across and up to 8,000 rows down. So manual manipulation is not only horrid but a risk of error. Column's 'A' and 'B' are...