pull

I am putting together a database that I'd like to be able to have a macro assigned to a button that will take the information I have, and add it to a table that will continuously update. I'll build an invoice (or pre-invoice), and I'd like the following data to populate from the invoice, to the...

Hey there! So...my boss creates these very confusing and messy schedules. I would like to make a auto-populated streamlined version of his schedule. Here is a link to my worksheet (its just a dummy containing no personal information)...

I am trying to dump yearly data into a sheet then on another tab pull the info based off a name and the date entered. Column A Date Column B Name Column C through M is data to pull

I have a formula to query every 12th line using the index function. For some reason it is pulling every single line rather than every 12th line? I cannot seem to make the every 12th line work on it? Why does it pull every individual line? =Query(INDEX('Jason Smith'!$C$1:$C,(ROWS('Jason...

Hi Experts and all, I have new and very 1st query on access db. Table name "Data", contains 4th and 5th column email id's. I want to fetch that in variable. Can any one provide me select query, how to write that.. Many Thanks..

Hello, I am writing an addition to a userform that will pull data to another worksheet from the selected row. I have several cells in a row that are fed by the result of option buttons, all connected by a frame on the userform. I need to add to a data pull a step that will, once a row is...

Hello, I have directory with multiple excel files and I need to pull the first 5 lines of only the first file in the directory into a new sheet. Can anyone help? Thanks in advance!

Hi. Is there a way I can make my own stock screener that will pull data off line so I can sort by my own custom parameters?

Hi everyone - I am trying to create a macro to pull a specific cell from multiple workbooks. This cell will remain the same throughout (A1). The issue I am running into is when the macro is ran it does not immediately identify the sheet. When ran it will force you to select the correct sheet...

i’m trying to pull in all values in a specified date range. The data is on a separate tab and delineated by discrete dates. I need to sum all the dollars in a specific range. Please let me know if you have any ideas. Thanksb

Hey Folks! I'm trying to figure out how to capture specific locations in a cell. <tbody> <tbody> Basically below is a column from a report I pull. My boss would like me to be able to pull out the speedtest download and upload and show it in a report with the areas that are associated with...

Hello- Here is my setup. I have a data connection in Excel that runs a SQL query. There are 2 parameters, year and month, that point to cells in excel. I would like if month is left blank to pull everything for the year. For instance If year = 2017 and month = 12 pull december of 2017 If year...

Hi, I am building a document auditing spreadsheet. All of our documents should have " -dd mmm yyyy" at the end. I want to extract these characters into three columns. I can pull the day using RIGHT formula as these cannot have a zero such as 03. But I'm struggling with the month and year. I can...

Hi Everyone, I'm trying to filter data from one tab to multiple tabs based on a specific value on Tab 1. In this case on a person's name. If the data in the row in question has a leader's name, then pull all that data in that row to the appropriate tab. There would be multiple columns to pull...

Hi Everyone, I'm trying to filter data from one tab to multiple tabs based on a specific value on Tab 1. In this case on a person's name. If the data in the row in question has a leader's name, then pull all that data in that row to the appropriate tab. There would be multiple columns to...

Option Explicit Function StripChar(Txt As String) As String With CreateObject("VBScript.RegExp") .Global = True .Pattern = "\D" StripChar = .Replace(Txt, "") End With End Function Sub PullNumbers() Range("E2").Select ActiveCell.Formula = "=StripChar(A2)" Range("E2").Select...

Hi Im trying to pull images from hard drive locations into a userform multipage, but it displays the image behind the multipage. I'm trying to put the picture in Image1 on the userform. This is what i got so far. Sub Addpictures() MultiPage1.Value = 0 Set img =...

I have a field that is a string but at the end has (2) or other number. The string lengths vary. I need the integer as it's own field. ie The brown rabbit (3) The blue ox (10) new field 3 10 thanks

Hello, I have a spreadsheet where I want to pull rows 11-17 from each tab into a summary sheet. All of the tabs have the same structure, but different data for each market, so I'm trying pull it all into one data source. Can anyone advise on how I can do this with VBA? Thanks!

Hi All, Ok so I have been working on a spread sheet for my work and I am trying to have excel go down 2 columns(S & Y) and pull only the first entry of each name and have them separated in row 1, columns C through I. Because of the information on this spreadsheet, I can only give the data in...