source

I am trying to pass a Listbox multicolumn selection over to another multicolumn Listbox on another open Userform, but only if there is text on at least one of the source listbox columns/ I have tried listdest.additem listdest.list(listdest.listcount...

Dear Sir, I need to merge excel worksheets from multiple files in a single excel (master) file accordingly to their worksheet name. - If the worksheet already exists in the master file then it will insert (merge) data / rows below to existing data row in the master sheet or if not...

Morning All, I'm looking for a little advice on hyperlinks, I have a list of items within a table which has been drawn from a source file as a query. I have attempted to hyperlink the text of each item name to a worksheet within the same document, however due to the data being drawn from a...

Hello, I'm getting a self generated Microsoft Excel popup message: Is there any way to suppress this self generated Microsoft Excel pop-up message? Please let me know. Thank you! Pinaceous

Hi, I have made the following and I think my problem is in "Source = ..." how to make it indifferent to the starting point and simply using another query (Kolonne)=> let Source = Excel.CurrentWorkbook(){[Name="Shop"]}[Content], Replaced_Value =...

Anyone knows why (Copy - Destination) does not work but Pastespecial does? What is the most efficient way to copy from one table in workbook 1 to another table in workbook 2? Sub Import_data() Dim wb As Workbook, wb2 As Workbook Dim ws As Worksheet Dim vFile As Variant...

On my pivot table, I click 'change Data source' and click the table range that I need and click OK. I go back to the pivot click refresh, nothing happens, go back to the Change Data Source' and the old Data source is listed. Range - 'Open PO Raw Data'!$A$1:$AB$26160 (old source) range -...

Hi all, I am working on a little procedure to import data from one file into my Source workbook. Currently works fine although possibly long winded. A new requirement was added this morning to remove rows in the source workbook where they exist in the new workbook prior to importing them. The...

Hi I have an external data source in excel which I need a pivot table on, the data is growing and Im looking for a way of automatically changing (Expanding) the data source. The data comes from a web query and I am able to get the link from a right click on the data, but I cannot use this link...

Hello Excel-lent people! I wanted to make a userform where I would populate a textbox and want it's content to become the content or body of the email. With the code i have below, what it does is it attaches the worksheet instead as an attachment to the email and i believe one of those that...

=SUMPRODUCT(--('GRIP STAGES'!$C$5:$C$4000=$B8),'GRIP STAGES'!T$5:T$4000) How would I alter this so that it returns only the sum total of the source data that is filtered? thanks

Hi, I am plotting a scatter graph with values in column C vs column E. There are formulas from c1:c2000 and e1:e2000, and they have iferror statements to hide as "". I would like the chart to populate automatically hence the 2000 rows, even though just say 123 rows have actual values (the rest...

Hi everyone , firstly english is not my main language sorry for that.I have a main file which is working with 15 different source file.In the main file on A columns datas should be taken from source files on TOTAL sheets on A column.But the problem is a lot of data in TOTAL sheets and they are...

I have two workbooks with a sheet named "dashb". In one workbook I have a formula like this =dashb!L2 If i copy/paste that formula into the second workbook, it comes out like this: =[D4_p_TRK.xlsm]dashb!L2 In other words the old (source) workbook name is included in the formula. But, i want...

I am having trouble linking data in my consolidated workbook to an individual cell in a source worksheet in another workbook. I've tried = with then going to original worksheet cell, enter plus a couple of other things I found on the web. They are not working. Please help. I have rows of...

Dear All, I have got one excel (Destination file) file in which I have used SUMIFS function linked with another excel file (Source file). When I open the destination file and update links, instead of showing the amounts, it shows #VALUES . It will properly update only if I open the source file...

I am trying to use a cell value(Parameter), the same as I use with Microsoft query, but it is not working. Example: Select * from table where Date = ? Using Power Query Defined the Criteria let Source = Excel.CurrentWorkbook(){[Name="AsOfDateCriteria"]}[Content], #"Promoted Headers"...

There are 2 files. File A has links to a source file and was updated from that source at 10am. File B has links to the same source file and was updated from that source at 5pm. The source file changed between 10am and 5pm. If file A is opened after file B, the data in file B changes as if it...

so i have a workbook that's linked to another workbook...but the links aren't updating! the only way I can update the links is if 1) i manually go to the cell then enter again or 2) go to "data" -- > "edit links" --> "update values" or 3) i open both workbooks (workbook with links and...

Hello- I am a complete VBA beginner....however, I am attempting to write a macro to copy data from a source sheet to the current active destination sheet (same workbook). - The source sheet will vary. I created a drop down list of sheet names in coordinate "Q5". I'd like the macro to refer...