• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Script to pull from another book matching data

    Hi could anyone help me with code to do the following... any help really appreciated. Main workbook = Workbook1 Data is in = Workbook2 Using VBA i'd like return all matching PO numbers from column D where the date in column E is todays date (column E is formatting General, i cant change this...
  2. K

    User form listbox filter

    Hi i think this is it... Could you explain what the lines of code are doing for a Newbie :)
  3. K

    User form listbox filter

    ok yes no problem... its column 16 and 17.... so 16 has to equal Y and 17 to be blank
  4. K

    User form listbox filter

    Hi all, I have a listbox (listbox) that displays a sheet columns a to v (1 to 23). I have buttons that I'd like to apply a filter to 2 columns. So user clicks the button then if column 18 equals Y and 19 equals blank display the filtered results in my listbox1
  5. K

    Optimize VBA

    Ok sorry yes I have code for copy and paste data from sheet to sheet based on a column value this happens on 2 sheets (Scheduled and On Site). When I choose option On site or completed from the dropdown and the line moves the process seams sluggish and this is with little data so when i fills up...
  6. K

    Optimize VBA

    Hi all, I've done some coding but as im a newbie I think its a bit sloppy and the code runs slow could anyone take a look and see where im causing slowdowns please?
  7. K

    Copying formulas, formatting etc automatically

    Hi vletm, I thought it maybe easier for VBA to search for the last empty row with no data in and add all the formatting etc to this last empty row. So the sheet starts blank, apart from the headers (row 2) and the hidden row (row 1). So Id need the code to copy formatting, formulas, data...
  8. K

    Copying formulas, formatting etc automatically

    Hi :) I have a hidden row at the top of my sheet that has all the formatting, formulas, data validation etc applied, currently when I creating new rows (and not able to drag down due to end of data) I copy from this hidden row and paste in the new row create after the last line of data (and...
  9. K

    Sharing a workbook

    Hi all, I have a workbook that's taken months to almost finalize, work now want it shareable so multiple people can edit at the same time but I have a lot of tables and pivot tables and the need for formulas to copy into new rows. What options do I have ?
  10. K

    Updating main file from externel

    So the Master file is on the works network drive, this is for the admin use in the office... Work now wants operatives to edit this file but due to the amount of people touching it I want a seperate file that just adds and edits one sheet and they can not mess with the rest of the data. We don't...
  11. K

    Updating main file from externel

    Hi all, I'm in need of some scripting... I have a main workbook that holds all the data, now I'm in need of a seperate workbook that users can enter new information that updates the main book. I have created this book and general layout but not sure about coding it to copy to main. In file...
  12. K

    Code edit - checking cell and adding data before running

    Hi, Can anyone help edit this code... What id like is this... If selection is 'Completed' check if cell in column 'U' is 'Y' and cell in column 'V' is 'Y'.... if they are true allow the rest of the code to run. If there is no 'Y' in either column the transfer can go ahead, if only a Y in U then...
  13. K

    Data validation

    As above is spot on... So the user can not leave a zero in those cells or leave it blank and likevyouvsay first option would suit best
  14. K

    Data validation

    If check appears it's because a zero has been entered in the 4 columns next to po number I want only greater than zero
  15. K

    Data validation

    Hi thanks for the education i didnt know this :).... cheeky question do you know the VBA code?
  16. K

    Data validation

    Would you mind taking a look at this workbook (its is a trimmed down version with only what you need to see available). So i've decided now to put data validation on the 'Approve' column checking that cells equal "Pass". If those cells change to "Check" I want it to stop the user and tell...
  17. K

    Data validation

    So if it's a "pass" then no action needs to be taken but when that cell changes to "check" I need a validation that only a number greater than zero should be in this cell
  18. K

    Data validation

    Hi this doesn't work if i enter a number higher than zero im getting a stop validation message...Does this mean it needs to know what happens when cell = Pass too? If cell is pass i want numbers to be greater than 0
  19. K

    Data validation

    Hi everyone, I'm trying to use data validation on a cell with a formula result but nothing seams to be happening... Column Y has the formulas in giving result 'check' or 'pass'... In column K I want to validate the cell so if You equals 'Check' then K cell needs to be greater than zero.
  20. K

    Automating input and validating

    Hi, i have tried all this in the work environment but getting complaints automatic input isn't fast enough and they don't like the PO check method... Sorry to be a pain but could you change it to do it this way... 1) user inputs a PO number into the PO column.. 2) in the background VBA checks...
  21. K

    Automating input and validating

    this is excellent... a few problems... 1) when searching for a po if it already exists id like it to still allow it to be used but the numbers to be all zeros. if it does not exist id like that po inserted but then the numbers that follow have to be greater than 0 so PO exists = PO123456 ...
  22. K

    Automating input and validating

    In Progress.... Sorry yes forgot the important detail there
  23. K

    Automating input and validating

    Sorry Dropbox doesnt seam to be working properly Ill try Google Drive https://drive.google.com/open?id=10hl-UpvZeJUEkCwONJ8FDVo99PB8xc3i
  24. K

    Automating input and validating

    Hi I cant upload using this site as file is too large Here is a dropbox link to the file https://www.dropbox.com/s/u8xm9jlfuxco16g/Goods%20In%20-%20KPI.xlsb?dl=0
  25. K

    Automating input and validating

    Hi, generally it is random, the information is inputted based on how they get it on paper to transfer, eventually I'd like a pop-up box that forces order.
Back
Top