source

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

I need to count how many times an item went from a certain source, and afterwards from which source it went the most. Say... <tbody> Source Item Wallmart Apple Wallmart Apple Newegg Apple Target Apple Wallmart Apple Target Apple Wallmart Apple </tbody> How do I, on a new...

I have 150 sheets inside 1 workbook, they need to be ordered exactly as listed in a column on a separate sheet. Example (SheetA, SheetB, SheetC, ect) These sheets have been renamed, and every macro I've found online is re-ordering based on the "Sheets Property (Name)" not by the actual naming...

I am trying to import a QBB file into Excel 2016. In older versions, you could use the import from other source feature but I don't see that option in 2016.

Hello, Based on my research on this forum, I've learn't that SUMIFS formula does not work when the source data workbook is closed, once the recepient workbook is refreshed the values go to #VALUE error. I've read that the SUMPRODUCT formula can be manipulated to achieve the same result and...

I am trying to use a list from Excel as the source for a combo box in Word 2013. Is there any to do this?

I am coding a large vba project for work, and I am working on putting all of the source code in an add in, so that all 50-100 copies of the program that will be in circulation pull their code from the right place. The internet seems to agree that this is the best way to do it, however I can only...

Hi, I have an excel which is the source document containing the following data. Column A - Process Name Column B - Date Column C-G - data I want the code to read the Process Name in column A (source) and open respective excel document (destination) read the date in Column B (source) and go...

Hi all, Using Office 365. Is there a way to update the Data Source for all of my Pivot Tables that are connected to 9 Slicers? When I try to update the first Pivot Table, I receive a warning message How can I update all Pivot Tables at the same time to defeat the warning? Thanks, -Lou

Hello Friends, I have to do data compare from two data sources treating first data as correct and highlight any data point in the second data source that doesn't match the data point in the first data source. Example - Any difference in source B row should be highlighted. The original excel...

Hello Friends, I want to compare two subsequent rows and highlight all the differences. Example - Treat source A row as the correct data. If source B row data mismatches source A row, highlight it automatically as shown. There are about 60 values to compare (62 columns) and about 20,000 rows in...

Hello, trying to get the price from the website: https://www.tesco.com/groceries/en-GB/products/303105747 So would return £3.00 Any ideas, this is my attempt? Thanks in advance! Sub WebData() Dim http As New XMLHTTP60, html As New HTMLDocument Dim source As Object With http...

Good afternoon Guru's I'm racking my brain with the best way forward on this. I have two spreadsheets (similar examples attached), one holding source data and the second is used for reporting. The source data comes from another source and therefore doesn't contain comments (column G). The...

Say I have a table of 4 columns and I use power query to add a 5th custom column. Instead of loading the query to a fresh new excel table of 5 columns, can I instead, only load the 5th column to the source table in the worksheet? One reason could be to allow editing source data and also see the...

Hello, I have been working on a project where I have one file querying data from a set of other files, all found in one folder. I've gotten the query to function as expected, however I have seen a pattern of data from the source files being lost. I don't know if this is an issue in the files...

Hey all. I have a controlled data source generated several times a day from one of our customers. I used the data to verify some of record and update forecasts, etc. The problem is, of the 100,000 plus cells, ~20,000 cells spread throughout the spreadsheet are not formatted correctly. Double...

Good Evening All, So I'm having a problem copying text from one workbook to another and keeping the source formatting. Normally a person can use PasteSpecial or xlpaste:= and this can be accomplished. I think that my code that copies things and then pastes is the problem as it does not allow...

Context: I am trying to automate a task through a macro. I have a source file and a destination file and dumping in specific data from the source file onto the destination file. However, since the source file has a different table layout, I created a hidden sheet in the destination file to hold...

Hi all having an issue where i run the below code: Sub UpdateLinks() Dim Location As Variant Dim File_Name As String Application.ScreenUpdating = False Application.EnableEvents = False Call unprotect For i = 5 To WS_Admin.Range("C4").End(xlDown).Row File_Name =...

hi I have some code which has been working really well importing data from other files into a central file. Here is the code...