grab

Hello. I have two workbooks. Pickorder and DWP. Both have the same route codes listed (Ex. CR1) However, only one (DWP) lists the DSP that will be taking the route. So this code identifies the matching route codes and on the DWP sheet grabs the value in the left cell which is the dsp and pastes...

My Data Range is B4:L10 consisting of 5 columns (B,E,H,J & L)as shown plus B2, E2, H2, J2 & L2 is either of 1 or 0 Output required in N4:N10 as ‘grab’ the value from the corresponding row cell of B4:L10 which has 1 in B2:L2. How to accomplish? Thanks in advance I am using Excel 2007 Sheet1...

Hello. I'm looking for suggestions on how I would go about modernizing this. In short, I have a table that lists employees and splits their allocations across multiple programs. It is in its own workbook, and I currently link several workbooks to it. Picture this table with many more...

I'm at a loss for how to solve this one. I need to grab part numbers from column A on specific named sheets within the workbook. Lets say they are sheets named "1" "2" and "3". When i run the macro i need it to grab everything in column A from these sheets and put them compiled into the A column...

I am attempting to grab pieces of address info off a website however, I'm not able to grab the correct data: I want to be able to grab the Street as on variable, city and state as another, and finally the zip. Here is the html code I am trying to scrape: ==$0 ...

Hello, I have an issue where i have a shipping chart and want to use vlookup on the weight to grab a shipping price. the only thing is that anything past 150 lbs will be charged $0.47 per pound thats over 150. So lets say a have the weight in row B. B2 = 200. If B2 > 150 it needs to grab the...

Hello all, This might get a little complicated to explain, but I will do my best. I have two sheets in a workbook, one called “New Extract” and another called “Error Tabulation.” The “New Extract” tab contain 100 rows of data (101 if you include the header row), and 266 columns. The columns are...

Dont know if this is possible, but I thought i would ask... So instead of having to "grab" the scroll bars using the cursor, you could just "grab" anywhere on the sheet and move the sheet up and down. Possible? Here is why I am inquiring: My worksheet/workbook (which is a org char) is...

I am trying to grab all the data from column a and b and put it in c. Thanks!

Hi forum, I have a number of sheets that have similar columns with this years total sales and last years sales. On the bottom I'm doing a total, of YTD, but when a month changes, I have to manually go to every last year column and say only sum up to current month. In other places I am using a...

<tbody> date amount 1/1/15 1 1/2/15 2 1/3/15 3 1/4/15 4 1/5/15 </tbody> Hello everyone, Assuming that the table starts at cell A1, this is what i am trying to accomplish: I have excel 2016 and utilized the MINIFS formula and was able to grab 1/15/15 date by using...

I am using a MAXIFS formula to determin a MAX value based on date and day from antother sheet Problem is if there is no value on a date it will return 0. I need a formula that states IF the MAX returns 0, then it should just grab the number on the date above it. ex...

looking for some help and hopefully solution please folks 2 sheets 1st sheet data entry 2nd sheet display 1st sheet in column A some cells blank some contain a dropdown selection selections are example OP or TA or OC up to about 10 selections column b will have a name against this...

In a spreadsheet I have I like to a column label and a row header in a formula. The formula looks like this: =+'[2018 GNC DC_.xlsx]JAN, 2018'!E4 The "GNC spot" I'd like to grab from the text in B27. In other rows there will be other text The "JAN spot" I'd like tp grab from the text in C26...

Hello gang. I'm trying to write a code to grab data from files that others can update. The format is the same but they will have different names. I need to be able to run the my master file, but grab the data from this update file. Now, I can do this using application.GetOpenFilename as...

How do i get the cells for the header row with blanks? There are some blanks in between columns but I want to grab the blanks as well...The thing is I don't want to grab the trailing blanks at the end. I have this Set HeaderRange = Dataws.Rows(HeaderRow).SpecialCells(xlCellTypeConstants)...

I have a workbook that has multiple sheets and I use the VLOOKUP to grab certain info on a particular date to populate a cell on a form. The simple formula I use to grab a simple single entry is =VLOOKUP(A15,MSEQ648!A:F,6,FALSE), where A15 is the cell that references the time/date row and then...

Good Afternoon Everyone My english is not perfect... sorry about that In my work we have a database of clients in html format so we can consult that information with clients numbers. What im trying is to import client info. to excel page: I can do that when i go to data>from web>put the...