Search results

sorry guys, i tried to get it to work but it wont run at all now

thanks again Alan, just a short question if i may. i notice that all references to ws7 have an apostrophe in front of them, and then immediately after ws 7, ws8 is out dented. Firstly, why is this the case, and secondly what do i have to do to add back in the removed one (GC) given that it would...

thanks Alan, i didn't do anything unusual, (that i know of anyway :). I created the module, cut and pasted the macro into the module, inserted a Form button (top of ws1), assigned the macro, saved it, then tried to run it. i tried to debug it first and got the yellow highlighted line appear. I...

hi Alan, tried to apply the revised Macro but it came up with this i had redone the sheet as the tabs numbering was slightly different to my original numbering meaning the original macro had to be modified slightly, but now i'm not sure what to do. the new file is uploaded to

very much appreciate your help, thank you. I am still learning (obviously) but getting better with the help of people like yourself. I think i would prefer to clear the sub sheets and repopulate each time. A little bit longer time as the list grows would not be an issue, however people reading...

Mate, that is absolutely brilliant thank you. i think part of my failed attempts was that i had multiple sets of initials but not matching multiple pages. However, i have found one issue in that each time i run the macro it copies a previously copied row again, and adds it to the list on each...

Hi, i have seen similar threads but not exactly what i am looking for. Most copy from multiple sheets to one sheet, i am trying to go in reverse of that. I have uploaded the file in question, which is a list of all tenders we are advised of, then criteria to determine which ones my company wants...

hi, firstly thanks to those that helped me get this far. I've learnt a lot along the way, but need a bit more assistance please if anyone can help. i have a spreadsheet that is a listing for all projects or jobs my business has running. What i am trying to do is after having created the file...

Thanks Chihiro, file attached. Currently, the user starts to type the custoemr number in column D which then autofills. the customer number in column A will autofill column D. The user then filters Column C to see waht the last number was for that customer, type the next job number in Column B...

i now have a further issue. i have solved creation of the folders, but now want to automatically name and place the folder. i want to to look in the Projects directory to see if there is a folder existing based on the last line of text, (in this case 5278, Line 41), then search for Customer...

excellent thank you

Thanks Chihiro but that only does the same thing, ie: create a folder. i want to copy an existing master project folder that contains proformas for use during a project

Thanks for your prompt response Hui. I knew when writing it was going to be difficult to explain what i was trying to do. i'm aware of the mkDir function, and its sort of right but not quite. i have the new job as shown at Line 41:- Line 41 will be populated, and once complete, i want to be...

hi, have a perplexing problem. i run an engineering company. we have a spreadsheet with multiple columns for customer number (4 digits), job number (4 digits), plus description of the work, $ value etc. Each new job enters the data for the new job on the next row in the spreadsheet. What i am...