Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Getting Power Query to add new values to the bottom

    sandy666 thank you i got it working!
  2. Re: Getting Power Query to add new values to the bottom

    sandy666 sorry for not understanding fully im no expert with this (As you may be able to tell) where and how do i add this?
  3. Getting Power Query to add new values to the bottom

    Hi All,

    I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel.

    so i have separate tables for items which can contain a varied amount...
  4. Re: VBA or formula to run a look up based on a cell value

    DanteAmor thank you so much works perfectly.
  5. VBA or formula to run a look up based on a cell value

    Hi All,

    i have been looking at many different ways on how to do this, its more than likely very simple but i just cannot figure it out.

    i want to look up a value in another sheet based on...
  6. Re: VBA only allows 2 rows then starts to overwrite why?

    Fluff - thank you for your help worked perfectly.
  7. Re: VBA only allows 2 rows then starts to overwrite why?

    Fluff only when rows are moved but yes it is something that is always there as its the number of item.
  8. VBA only allows 2 rows then starts to overwrite why?

    Hi All,

    i have the below VBA code. when a row is marked as "CLOSED" on another tab the row moves to a new tab. but there seems to be an error with the code as it only allows 2 rows in the new tab...
  9. Re: sum a column if another column does not contain specific text

    stevethefish thats the one - thank you!
  10. sum a column if another column does not contain specific text

    Hi Guys,

    apologies if this has been answered before. i have a table which needs to look for specific values and if that value does not exist in the cell count another cell.

    so what i mean by...
  11. Replies
    0
    Views
    134

    Copy Unique Values to a new table VBA

    Hi All,

    i have the below code which copies rows from a table that is >0 in a specific column to a new table to eliminate the blanks. the code works perfectly fine for another table and i tried to...
  12. Re: My VBA is messing with date formats - how do i stop it?

    works perfectly too - thank you!
  13. Re: My VBA is messing with date formats - how do i stop it?

    Works perfectly thank you!
  14. My VBA is messing with date formats - how do i stop it?

    Hi All, i have the below VBA code which trims each cell but i have dates in the workbook and it seems to mess with the date format which then forces you to double click in each cell to correct. Not...
  15. Re: Save a range to a new workbook and save as a specific title?

    Thank you so much! works a dream!

    i was able to update the line
    fname = Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1) & Format(Date, "_YYMMDD") to
    fname =...
  16. Save a range to a new workbook and save as a specific title?

    HI All,

    bit of a strange one, i have been researching and cannot find anything relating to this. but i want to save a range in a workbook to a new workbook in a specific location under a new...
  17. Replies
    3
    Views
    160

    Re: VBA loop trough until cell is blank

    works perfectly - thank you!
  18. Replies
    3
    Views
    160

    VBA loop trough until cell is blank

    Hi All, i have the below code at the moment it just runs on cell Z1 but i want it to move down column Z fetching the data until the cells are blank so the code would run complete Z1 then loop round...
  19. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    Thank you - its working now i didn't realise the cells were not blank my mistake! i didn't think they would be populated as its come from a database but anyway thank you so much for your help!
  20. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    So have done the above - it works but what is really strange is if i copy the data from #10 it works if i copy the data from my spreadsheet the code dose nothing but they are identical?

    i put...
  21. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    Yes that is correct it should look how you have it - using the code below nothing happens?


    Sub...
  22. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    My apologies it is working but only when i remove excess data, the example i gave above was how i wanted the data to be displayed but the actual data has multiple rows in like so:




    <tbody>...
  23. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    Thank you - i have tested this and nothing seems to happen it gets to


    For i = LBound(vb, 1) To UBound(vb, 1) - 1

    and goes straight to End.
  24. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    Sure:

    Before:

    1 N O
    2 Test 1
    3 --------Listed
    4 Test 2
    5 --------Listed
    6 Test 3
  25. Replies
    16
    Views
    565

    Re: VBA to move a cell value up if blank

    Thanks - it dose not seem to work - it changes all values to the same for some reason.
Results 1 to 25 of 96
Page 1 of 4 1 2 3 4