source

  1. John.McLaughlin

    When copying Cells A thru E from the source workbook, it only pastes columns C & D in the destination workbook?

    When copying Cells A thru E from the source workbook, it only pastes columns C & D in the destination workbook? My Source workbook is an individual customers order with a worksheet named "List" My destination workbook is named Pending and contains the worksheet "Sold" The macro finds the last...
  2. S

    Copy the contents of a multicolumn listbox to another multicolumn on another Userfrom

    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...
  3. A

    Excel sheets merging

    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...
  4. M

    Hyperlink issues - Hyperlinking cell that is part of a query

    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...
  5. Pinaceous

    Microsoft Excel (pop-up msg)

    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
  6. R

    can't get a function to work

    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 =...
  7. H

    Copy from one table to another

    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...
  8. R

    Data source reverts back to old selection

    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 -...
  9. A

    delete rows in source workbook if they exist in another workbook

    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...
  10. W

    Pivot Table Data Source

    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...
  11. K

    Excel cell values transferred as Email body content

    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...
  12. C

    Sum Product on filtered data only

    =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
  13. C

    Scatter Chart Plot Order

    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...
  14. S

    Take data from another close excel workbook with macro

    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...
  15. T

    can I paste a formula to a new workbook that refers to a sheet in the new workbook, not the old one?

    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...
  16. J

    Link cell in new worksheet to another cell in source worksheet. They are in different workbooks

    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...
  17. A

    External Links not updating for closed files

    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...
  18. R

    Use Cell value in Sql Query

    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"...
  19. D

    Numbers in linked files changing without updating links (shared source and cache?)

    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...
  20. D

    links not updating!

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top