source

I have to copy column A, C and D from source file (sheet name"Input") to column A,B and C in destination file (sheet "sections"). But the source file name keeps changing every time new data is recorded. Can i use workbooks(1) and workbooks(2) instead of specifying workbook name if these are the...

Hi, Can you advise please what ive missed in the code below. I run the code. I see the msg box with the oK button. Pressing OK just does nothing & im unable to close the msgbox. Option Explicit Private Sub DatabaseCustomerDuplicateSearch_Click() Dim Cell As Variant Dim Source As Range Set...

how can i shorten up a range with usedrange in a range? or how to properly use last row used xlup? something like: set source = range ("E3:E4000").usedrange or set source = range ("E3").end.xlup Set source = Range("E3:E4000") source.Interior.Color = xlNone For Each cell In source...

Hi, So i have these spreadsheets with database connections and which then get uploaded into a datamodel. Now my question is specifically about the data model, if i change the source to a different table with the exact same layout it works great and i don't need to do any editing all the DAX...

I have a file linked to another. Nothing fancy, 3 rows 4 columns in columns D-G with the formula ='F:\[Historic costs.xlsb]Historic costs'!B14 copied down and across. When I open the file (with the source closed) the data in columns D,E and G are fine, but the links in col F have a #DIV/0...

Right now I've set up the query to pull form a folder. However, I'd like to move the files to a different folder/location. So I went ahead and did that. Then I went into query editor and double clicked on "Source" under applied steps. I changed it to the new folder and hit "OK." I get this...

I am trying to delete old files from a folder. file names are in column C and old files are colored RGB(255,0,0) i get an error when running this code." file not found". i tried peacing different codes together but, i'm still learning. Sub Delete_test() Dim MyFolder As String Dim MyFile As...

Hello, Everyone Recently i want develop one code which it solve my problem for my excel book this code is about copy several cell values on one workbook to another workbook base of the criteria of cell there are two workbook here 1. source workbook name is Source and the worksheet name...

I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I try to use it in a query: Expression.Error: We cannot convert a value of type Function to type...

Hi, Hoping someone could help me with this. I've been trying to find a way to do this and just can't get there. What I have is a combined spreadsheet that prior was multiple workbooks/sheets (don't have the original) and was combined into one very large worksheet. Each segment of the...

Evening, I have a few macros that do various thing. Ordinarily I would use the Macro recorder to help me but the macro recorder doesn't work with Queries & Connections. Are you able to tell me what code I would need to put in in order to create a Macro that gets me to the Source option that...

Hope someone can help with this, I have a a csv text file that needs importing to a template then modifying using power query. Trying to find a way of being prompted with a dialog box for the source file so different named source files from different locations can be imported to the same...

I still have access to an intern's account who no longer works here. He created a report in "Service" under his "personal workspace" so there isn't an option to download the *.pbix file. So I ended up going to "Desktop" and I was able to select the same dataset he used in "Service" and I...

Good morning ... I'm not sure if this can be done, or even how exactly to describe it, but here goes ... I need to create a "ballot" file, which I will then refer to after generating a random number using a formula. I have a source spreadsheet with names and the # of ballots each name gets...

Hi all, I'm hoping someone has come across this and has a fix for me :) I'm extracting data from several files, each file has the same structure and I'm pulling multiple tables (but not stored as tables) from 20+ sheets in each. While all source files are closed the execution takes roughly...

Hello, Self taught daily user that occasionally dreams that I have to VLOOKUP people before I can speak to them.. :eeek: I have many pivots per tab. I deleted the source data and replaced it with new data and refreshed all. Some of the filters did not keep, and some did. How do I lock down...

I have a workbook that I keep monthly and it has a new work sheet for every day in the month. I need to create a formula that searches the entire workbook for instances that meet 2 specific criteria. The formula will be in a separate workbook so I need to find out how to reference the source...

Need your advice on the best way to handle vendors that are the same just called differently in the data I receive. One data source may call the vendor something different than another data source. I.e. abc co. Vs abc company. Or St Joseph’s vs Saint Joseph’s. What is the best way to handle...

Hi, I need to pull a column from a dynamic data source based off one unique id(Math). Can someone help with a formula? I need to pull all names associated with the unique id onto another sheet. In a listed column. Example below: Data Source: <tbody> Name Class Ron Math Amy Science...

Hi, i'm trying to write some VBA code to open several workbooks, copy a column, and past into the book I run the macro from. I need the data I copy over to all go into the same column. Here is my code: Sub MeToo_Paste() 'Assign Report Book Dim x As Workbook 'Assign Source Books Dim y As Workbook...