Search:

Type: Posts; User: Factotum; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Table edits not included in query refresh

    Please ignore my stupid question:oops:

    Such a simple mistake - I made changes to Table B, but didn't save the changes. Therefore, when the query updated, it was pulling in the last saved values...
  2. Table edits not included in query refresh

    I've appended two Excel tables (A and B) using Power Query. So far so good. Table A is a connection only to another Excel file. Table B is in another sheet of the workbook where my query results get...
  3. Replies
    2
    Views
    410

    Re: Using Excel while queries are refreshing

    I kinda figured that would be the answer. Thanks for confirming my fears. As another option, and maybe this depends on computer settings, would a query continue to run/update if I locked my computer...
  4. Replies
    2
    Views
    410

    Using Excel while queries are refreshing

    This may be a silly question, but does anyone know what the effect will be if I'm actively using other instances of Excel while the queries in another workbook are refreshing?

    I've been working...
  5. Re: Power Query - import multiple files from SharePoint

    Matt, I know it's been a while since this post, but life kinda got in the way. The link you shared appears to be the ticket - I've finally been able to connect to my SharePoint library and got the...
  6. Replies
    4
    Views
    443

    Re: If Less Than or Greater Than

    Sandy - thank you for adding the sample data. It was on my list to do, but I kept getting sidetracked.

    Bardd - you nailed it! Thank you for your help - your solution works perfectly!
  7. Replies
    4
    Views
    443

    If Less Than or Greater Than

    This is probably a simple fix, but I'm really new to Power Query and can't find an answer. I'm trying to compare square footage between two systems, but want to ignore any potential rounding...
  8. Re: Power Query - import multiple files from SharePoint

    Thanks for the suggestion Matt. Unfortunately I've already tried clearing my credentials numerous times. My organization recently changed its email and website domain, but the SharePoint I'm trying...
  9. Replies
    5
    Views
    483

    Re: Suggestions on where to learn the basics

    Thanks for the great suggestions!
  10. Power Query - import multiple files from SharePoint

    I've been all over the web trying to solve this one with no luck. I'm very new to Power Query, so please forgive any ignorance on my part. I'm the admin for a Sharepoint site with several libraries...
  11. Replies
    5
    Views
    483

    Suggestions on where to learn the basics

    Does anyone have suggestions on where to go back to the basics of learning VBA? I've been self-taught over the past six years by reverse engineering results from the macro recorder and Google...
  12. Re: Power Query - leaving detailed notes of steps

    Thank you all for the suggestions! I'm excited to find out what I can do with Power Query!
  13. Re: Power Query - leaving detailed notes of steps

    That's a fantastic idea on several levels. It gives me what I was asking for as far as comments/notes, but it might also help me learn Power Query better. I learned VBA mostly from the marco recorder...
  14. Power Query - leaving detailed notes of steps

    Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they...
  15. Replies
    1
    Views
    126

    Re: Convert selection to SQL ANY() format

    In case anyone is interested, I've come up with a solution - it's ugly and I'm sure there are better ways to do it. I realize that Select and GoTo are not good practice and I usually don't resort to...
  16. Replies
    1
    Views
    126

    Convert selection to SQL ANY() format

    I frequently need to convert a range of Excel data into an ANY() function format (table below) for PeopleSoft queries. Once I convert the format, I copy/paste into PeopleSoft. First column is an...
  17. Replies
    1
    Views
    100

    Re: Keep zero baseline in charts

    Looks like I should do my homework before agreeing to write a macro to do what the user wants. Turns out that what I was trying to do, and eventually succeeded in, is already an available function in...
  18. Replies
    1
    Views
    100

    Keep zero baseline in charts

    I've done a lot with VBA, but never anything relating to charts. I have a macro, courtesy of www.TheSpreadsheetGuru.com, which adjusts the Min/Max of the Y-Axis of a chart (see below). I would like...
  19. Re: Formula to find cell reference when row/column not known

    Rick - I'm not sure I phrased my initial question very well. The employee name will not always be consistent between sources, making it difficult to use Vlookups to other documents. For that reason,...
  20. Re: Formula to find cell reference when row/column not known

    Thanks kvsrinivasamurthy! I don't completely understand the formula you gave me, but it works beautifully. There's one additional thing I found that I'm trying to add in, but I can't find the right...
  21. Formula to find cell reference when row/column not known

    Could someone help me with a formula (not VBA) to lookup a value in another sheet and return the cell reference? The catch is that I don't know the row or column where the search value will be found....
  22. Re: Lose .xlsx designation when adding variable to Save As filename

    Thanks SpillerBD - I love it when solutions are simple like that. All I did was add & ".xlsx" to the end. I had tried that once, but didn't put the "" around it. Thanks for setting me straight!


    ...
  23. Lose .xlsx designation when adding variable to Save As filename

    Can anyone help me figure out where I'm going wrong? I'm trying to name a file: Department Name_Row Count_Sum of Amount.xlsx

    It works great until I try to add the sum in there. When I add the sum,...
  24. Re: Reduce processing time for splitting huge file into 25 smaller files

    pvr928 - thank you so much for getting me started down this train of thought. I have much to learn, but I'm excited about it. To the rest of you, thank you so much for helping me with code that I...
  25. Re: Reduce processing time for splitting huge file into 25 smaller files

    Thanks for the suggestion Fluff. I was researching this late last night and couldn't decide whether to use an Array, Collection, or Dictionary - I'm still not sure the difference, but I'll get there...
Results 1 to 25 of 108
Page 1 of 5 1 2 3 4