source

Hi I do not understand the for loop below. When I say for i=1 to i That is to me, I am assigning I to 1 and there will be no loop. I did step through but still can not see how "i" can be in the loop when it has been assigned to 1 and the max is i (to i). Can the code below be written in...

Good morning; I get multiple text files that need to be imported and parsed. I wanted to automate this function including allowing a user to navigate to the folder for the source files. Also, do not want to use VB since my company does not allow this. Any ideas? Thanks

Hello All, I've got a very large data set (setup layout below), which I am trying to sort without disrupting the adjacent column references... Column "A" has the headers, while columns B+ have successive months worth of data (e.g. Jan, Feb, Mar, etc), however, the data is being sourced from two...

Hello, I am trying to modify this vba code that would find rows containing 20 products and cut/paste them onto another sheet. I tried to add an elseif to this code but it is not working. I am new to this so any help would be appreciated. Sub CopyYes() Dim c As Range Dim j As Integer...

Hi, I am trying to copy all the files in a folder with Yesterdays date to a folder with Todays date. I have tried sharing the code I have written so far but its not looking like the codes in other posts. Sorry if the code is not loaded correctly. In my main sheet I have created a formula...

I have timestamp under Column A in this format: 2019-06-27T16:05-0400. I want only 16:05 from that timestamp i.e. hh:mm. Can someone help how we can do using macro? Source <tbody> 2019-06-27T16:05-0400 2019-06-27T16:10-0400 2019-06-27T16:35-0400 </tbody> Target: <tbody> 16:05 16:10...

I have been searching for a way to be able to read and write multiple files to .txt. I can currently get the most current file with a wildcard, but the other archived files are in sub-folders named by date i.e. 07072019. I would have two dates on a sheet, say B3 and C3. B3 being start date and...

Hi, This morning i came to use the drop down list but nothing happened. If i select the cell then data validation i see the following, SETTINGS Allow LIST which is correct Source =HONDANUMBERS which is correct I click on OK but see an error message The source currently evaluates to an error...

Hi, I have a table of data, it is a list of actions for different team members, so the columns are: A1 = action number, A2 = name of the team member, A3 the Action assigned. I want to have 1 central database of actions with all of the teams work related actions on, this is the main source, BUT...

All - good evening Having some issues getting vba to work that specifically points two different data query table connections in one file to a specific separate source file. The specific source file is located in c:\Crop Chemical Database\Crop Chemical Database.xlsm I want the receiving...

Using a dependent dropdown, I have multiple values all with different source locations. I have used VLOOKUP to automatically populate a cell next to a drop-down. =VLOOKUP(C13,'SheetX'!C5:D5000,2,FALSE) However if I select B from the drop-down, how do I get VLOOKUP to do the same thing? The...

Hi, I have a rather specific query i need help with. I have a spreadsheet which has a series of cell values that relate to daily files we receive from around the business. As part of a wider process i run a series of macros to copy and move these files from their source folders. I would now...

Example of what i want: If in cell A3 I have the formula =A1+A2, and if i copy that to another sheet, cell A3, the pasted formula will be exactly "=A1+A2", and it will refer to the cells A1 and A2 in the destination sheet. The formulas are not changed to be hard-coded to refer back to the cells...

I am no able to find out how to highlight the source data values for a value selected in my pivot table. e.g. if I select a value (say 57111.25) in my pivot table then all the values/rows in the source data whose sum is that value (57111.25) should get highlighted/colored/numbered. There is a...

hi problem - I have found some code on the net that basically does what I want. I run the code and it loops through my data on sheet1 and outputs charts on sheet2. however the code gets the source data only from each row and does not allow for non contiguous data. my X axis data is always row...

Hello, I am using Office 2016 and Windows10. I have 4 files all in a SP doc library - 1 main file with connections to 3 Excel files in the same library. I originally set up the connection using Data > New Query > From File > From (Excel) Workbook. Users had permission errors, I did some...

I have an issue with my UserForm that I have researched extensively and can't quite find the solution. I have a multipage UserForm with a page for each of my 8 events we'll be attending for my work. A few of the ComboBoxes and Listboxes should be populated with identical information and...

I've created a simple action list template with source filters (the master). I need to create a separate tab for each source that shows only the actions originating from that source. Ideally when the master list is changed, the table on the source tab would update automatically. Any help /...

Hello, I am using the below code to update links Sub update() ActiveWorkbook.UpdateLink Name:="\\192.168.0.100\itex share\ITEX\DATA ENTRY.xlsm" _ , Type:=xlExcelLinks End Sub The code works fine when the source file is closed. but gives a debug msg when the...

Hi all, I have 2 workbooks I am working on and am stuck on a question regarding pivot tables/ pivot charts. In workbook 1 I have a Power Query that updates the workbook with ~20,000 rows of data. In workbook 2 I am trying to create a dashboard containing a pivot table and pivot chart of the...