pull

Hello, Getting confused with Div tags etc. Any guide for this? How do you pull a "$0" from html in VBA via XML? Thanks.

Hi, I have multiple (hundreds) of archived spreadsheets consisting of the same mix of tabs and content format (only the data is different). I want to add an extra tab (lets call it 'Tracker') to pull bits of data from the various tabs into one easy to copy n paste column. Simple. :) What I then...

Hello, I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution. Sample Data on Worksheet1: On Worksheet2 I would like to pull anything that says 'Yes' in...

This is my formula that returns the 1st value but I need to return the data from the 2nd and so on. My project is to pull data to populate invoices based on the invoice number. =VLOOKUP(value(rngInvoice),Received_Process, 2,false)

Hi all I know there's been multiple posts on this throughout the past but all with slightly different requirements... I have a list of c.1500 names (some with middle names, some without) and i'm trying to split them out by title, first, middle (if there is one) and surname. I've tried text to...

Good day, all I'm looking for help creating a macro that will reference a list of unique values, pull 21 of those values to another sheet, and not duplicate those values when I request to pull another 21 values. Example: Sheet1 has 250 unique values in column A Need to pull 21 of these values...

Hi I have a sheet column C contains a formula +wo 1'!n1 this looks a cell on sheet wo 1 what I want to do id if cell B is blank enter 0 if not pull in n1 from sheet wo 1 thanks steve

Didn't quite know how to word the title... I keep a spreadsheet of music, albums that have come out every year going back to the 70's. As I listen, i score them. One sheet for each year, column A is the artist, B is the title, C is the score. I'd like to put a worksheet in front of all the...

Hey all, i use the following code to pull data from another workbook; =IF(INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW())=0;"";INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW())) The data in this...

Hoping someone can provide some help on this. I have a spreadsheet where people fill out the sheet with their skill assessments. Once those are filled out, the responses using the IF function and vlookup would populate the Development plan tab. Some of the items that get pulled into the...

I'm unsure what formula I need to return an adjacent value to the min value from a set of columns... My excel knowledge is very limited I have data in cells BC20 to CJ20 and down to BC136 and over to CJ136 I have numbers in every other column and text in between example: BC20 has pricing...

Hi, I have data in column D, and data in column E. I want to move this to column F (for printing) so that it runs D1 E1 D2 E2 D3 E3 Etc. I can pull the data D1 into F1, and E1 into F2, but when copying down, it does it like so: D1 E1 D3 E3 D5 E5 Is it possible to have it so that the...

<tbody> NAME LINE SUN MON TUE WED THUR FRI SAT LEE 1 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 OFF OFF OFF OFF JOHN 2 4:45 13:15 4:15 12:45 4:15 12:45 4:15 12:45 4:15 12:45 OFF OFF OFF OFF JAMES 3 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 OFF OFF OFF OFF...

I have these two variables: 1. MyRow 2. MyColumn I am identifying them with an input box entry So if myrow becomes A2 and mycolumn becomes F1 , then I am looking for a code to get that intersection (F2) for me. I will be placing some data at the intersection. But I don't know how to get the...

Hi, I have the following formula, it seems to work to the point that if the vlookup returns true then the 0 appears, but when false it will not pull through the value in cell N3. =IF(OR(VLOOKUP(A6,'Summary Source'!$E:$E,1,FALSE)=A6,VLOOKUP(A6,'Summary Source'!$F:$F,1,FALSE)=A6),0,SUM(N3))...

Hi All, New to the Excel world. Need your help in providing me the excel macro to pull the member details from outlook distribution list. Can any one help me. Thank You !! Regards, Santy

Hi guys, I've just started a new role and I need to find all duplicates in data over the past 6 months as my predecessor hadn't been doing this, and the idea of doing it manually for 8000 lines of data is terrifying me. Can anyone help me with VBA code to pull all duplicates into another...

How can I pull a cell number value from a table using a column and row reference. For example if I number the columns from 1 to 12 and I number he rows from 1 to 31 how can I pull the value from column 5; row 20?

Hello, So the cell contains "MattressSofaCouch-1", I currently have the isnumber function to identify whether it is a mattress, sofa or couch but I need an adjustment to the formula to designate the "-1" as the color black. Right now when I use the ISNUMBER formula and add the "-1", it pulls...

Hi, I'm trying to sumif one column with two conditions if possible. If I want to pull wte's total for all warehouses, it should be five. But when I put in the second condition to account for "whse 2", I get zero. Is it looking for both conditions in the same cell? How can I separate it to...