source

  1. R

    Clear All Permissions in Data Source Settings Using VBA

    Sounds simple but I cannot find any information on how to clear all permissions in Data -- > Get Data -- > Data Source Settings --> Clear Permissions --> Clear All I have trawled the internet for a while but sadly to no avail. If anyone could atleast tell me where in the object model I can...
  2. M

    Noob Help Please

    I am hoping someone can help. It seems like such an easy thing to do and I just can't find the answer anywhere. So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes" The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
  3. L

    advanced filter - OR vs AND

    Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...
  4. J

    Extract href link from source code using VBA

    Below is the source code which i am getting after browsing a website I just want to copy link /search/Listing/45678489?source=results in excel and want to know how to click it class="details" is same for all href links that i want copy while id keep on incrementing mk:1:mk, ms:2:mk and so on
  5. D

    VBA to copy data from multiple workbooks into single master xls

    Here is what I am trying to do. I have a few spreadsheets in a folder (c:\dump\tally). I am trying to grab the data found in A3:AA3 for each of these files in the "Rollup" tab and drop them into the Excel file hosting the macro in the Sheet1 tab. And since the source data is mostly formula...
  6. D

    Drop down list that can be expanded with new entries

    I need a drop down list of organisations for a cell. I have set it to allow list in the data validation settings but I am not sure of the code to go in the source box. The list is currently on a sheet called CSCs and is a table called tblOrganisation. If you need the table limits, it goes from...
  7. H

    Macro to copy all sheets from source workb

    I have a source workbook with several sheets. I would like to copy each sheet with the data into the destination workbook and to create sheets if these do not exist I am looking for code to do this Your assistance is most appreciated I have also posted on...
  8. S

    Formatting Inconsistent Source Data

    I'm trying to solve a problem to automate the formatting of some inconsistent source data we download daily for a partner. The source data is formatted like below. For the all lines we need to pull data into a simplified table. Ex. first line we need to pull the invoice # (11753195), Vendor...
  9. J

    VBA UserForm with Check Box

    I am trying to create a pretty simple UserForm that will contain 4-10 choices that I want end users to select all that apply and then create a text string based on their input. I have browsed the web but nothing seems really clear to me. Can anyone point me towards resources/step-by-step...
  10. H

    Blank Cells Copying As Zero

    hi I have some code I use to transfer huge chunks of data from a sheet in one file to another. Here is the code:- =IF(ISERROR(MATCH(1,INDEX((INT('/Users/SOS/Documents/My Documents/Horse/Football Advisor/Research/Master Data File/2017/Additional/New...
  11. D

    SQLITE Integration

    Hello everyone, Can you please tell me the best practice for importing SQLITE data into Excel? I want to create a pivot table for several users to access. I tried the get data from other source but doesn't seem to work
  12. gheyman

    Access: Form w/table as Source Filter

    When I have a Form based on a query, I am able to filter based on a Combo Box (Use the Combo selection as Criteria in Query). If you have a Form with its source being a Table, is there a way to filter the data? I only want to see records where [Status] is "Active"
  13. R

    VBA code for copying columns from one worksheet to another when source file is keeps changing

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

    Msgbox loop & unable to close msgbox

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

    last used cell in range xlup

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

    PowerPivot Source Change Keep Measures

    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...
  17. Johnny C

    Links updating incorrectly with a #DIV/0 error when source data is pasted values

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

    Power Query - Changing Source

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

    if file name in column C is red the delete that file from folder

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

    Copy several cell values into another workbook based of the criteria

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

Some videos you may like

This Week's Hot Topics

Top