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