Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Error: We Cannot Convert a value of Type Function to Type list

    I will give it a try!
  2. Re: Error: We Cannot Convert a value of Type Function to Type list

    I need the information to stay in table format unfortunately :(
  3. Replies
    2
    Views
    492

    Re: Lopp through table like macro????

    I will give it a try!!! Thanks!!!!
  4. Replies
    2
    Views
    492

    Lopp through table like macro????

    I am trying to figure out if you can loop through data in the table in power query. Here is my scenario. I have employees who receive a bilingual bonus (BB). This amount gets charged to a cost...
  5. Error: We Cannot Convert a value of Type Function to Type list

    I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I...
  6. Replies
    3
    Views
    484

    Re: Calculation of Net Working days

    WOW! The coding is way over my head!! Also, I want to include holidays.
  7. Replies
    3
    Views
    484

    Calculation of Net Working days

    Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query....
  8. Re: Custom or Conditional Column to Copy data to Null Cells

    Yes. I didn't realize it had that functionality. New to Power Query
  9. Re: Custom or Conditional Column to Copy data to Null Cells

    I figured it out. I am trying to make this harder than it needs to be :)
  10. Custom or Conditional Column to Copy data to Null Cells

    I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and...
  11. Replies
    1
    Views
    449

    Delete rows if a condition is not met

    I am just starting to learn to use Power Query. I would like to delete any rows that do not contain "Err" and keep any rows that have no data in a certain column. If I was writing code in a macro,...
  12. Switching Windows with Different File names

    I feel silly asking this but I just cannot figure it out. I have a macro workbook set up with form control buttons to pick the module you would like to run. The issue I am having is getting the...
  13. Re: VBA to copy and paste text from merged cells in a WB to merged cells in another

    Thank you!
  14. VBA to copy and paste text from merged cells in a WB to merged cells in another

    I know working with merged cells can be problematic. I have a workbook and I am trying to copy the text (which will change from month to month) within the merged cells and paste the text into merged...
  15. Re: Creating variables for file path names VBA

    I figured it out. I had a typo in the file path. I am so sorry I wasted for time. I must say I learn so many new things about macros from this site.
  16. Re: Creating variables for file path names VBA

    It is coming up blank :(
  17. Re: Creating variables for file path names VBA

    I entered the number 2. I want the result to be P2 in the file name.
  18. Re: Creating variables for file path names VBA

    I am getting run-time error '1004': Method 'SaveAs' of object'_Workbook' failed.
  19. Re: Creating variables for file path names VBA

    I guess I do not understand what you are asking me. I have a message box popping up asking to enter which period they are working on. Depending on the number entered will determine what PNumber is.
  20. Re: Creating variables for file path names VBA

    PNumber is going to change every month - it stands for period #. Period 2 is May, Period 3 is June, etc.
  21. Re: Creating variables for file path names VBA

    Now I ran into a different problem but it is similar. I think it may have to do with my brackets as the file name has a data that will change each month:

    Coding:

    'Ask user for the period of...
  22. Re: Creating variables for file path names VBA

    Thank everyone!!! I REALLY appreciate!!!
  23. Creating variables for file path names VBA

    I am writing coding for a rather large macro and I am trying to decrease the number of characters I use. One way to do this is to define a variable for the long file path name but it is not liking...
  24. Re: Problems with VBA coding to Create Pivot Tables after upgrade to Excel 2016

    You are a life saver!!!
  25. Problems with VBA coding to Create Pivot Tables after upgrade to Excel 2016

    I am trying to run all my macros to ensure they work since being upgraded to Office 2016. I am getting a "debug" error whenever the coding is trying to create a pivot table. I even recorded the...
Results 1 to 25 of 118
Page 1 of 5 1 2 3 4