Recent content by VKD
-
V
Find where three columns match in another spreadsheet
Thanks anyway, I got the macro to put the concatinating exquation in and then match that column then delete the equation at the end. Cheers! -
V
Find where three columns match in another spreadsheet
I am having problems with the find macro in Excel. I want to be able to match threes cells in on spreadsheet in another spreadsheet and copy the rest of the data. Basically I have a master spreadsheet with work to be carried out, this is sent to employees who then send a cut down version (eg... -
V
Macro to cut an paste row based on Cell value
No worries, figured this one out now. Now onto the next problem!! -
V
Macro to cut an paste row based on Cell value
My point is that I am using Holger's code (changed slightly for the nameing I have set up) but it is pasting all the data in the same line and not moving down a row. I have tried using lngFirstFree = wsDest.Cells(Rows.Count, "A").End(xlUp).Row + 1 but that only pastes in the 1st row in the... -
V
Macro to cut an paste row based on Cell value
Yes, Sorry didn't know if it should be in VB or excel. I don't understand what you mean about why haven't you modifed the code?? I have tried but I am not sure where I am going wrong hence why I wondered if anyone could point me in the right direction. -
V
Why is my cut and paste marco not working?
I have got a macro to work using a click button that will cut and paste data based on a specific cell value into a new worksheet. However I want to cut and paste more than one line, it is doing this but it keeps putting the pasted cells in the same row, eg if I have three rows to cut and paste... -
V
Macro to cut an paste row based on Cell value
This is great but and I have got it to work using a click button but I want to cut and paste more than one line. Which is is doing but it keeps putting the pasted cells in the same row, eg if I have three rows to cut and paste it pastes them all onto one row (which means you are left with just...