BASE813 0 #1 February 10, 2005 I am looking for someone to help me out with some code. I normally rely heavily on an internet list server for the code for my macros, but the code I need should be easy for someone with "knowledge" to do quite quickly rather than me look, retrieve, and then test, amend, and retest. Can you PM me please if you feel your Excel macro writing skills are able to help! thanks! Michael Quote Share this post Link to post Share on other sites
dan_iv 0 #2 February 10, 2005 just curious, what are you attempting to do with the excell macros? there is more then one way to skin a cat.... Quote Share this post Link to post Share on other sites
BASE813 0 #3 February 10, 2005 I have a spreadsheet that has lines of text on each of the rows in one column. I need the macro to search each row in turn in that column until it finds a set constant of a text string and on finding that then action a copy and paste from the row below to the cells on 1 column back until another set constant is found in the first search column and then repeat down to the bottom of a set range. I think this is the best way (and also possible with some almost simple code) as I used to use something similar on some formatting code I used at work - BUT I have all my code on my PC at work that I accumulated over 5 years but they sacked me after busting my leg and I never was able to get it all back! ARSE! thanks for any help..... PS) I am not great at explaining what I want sometimes! Quote Share this post Link to post Share on other sites
dan_iv 0 #4 February 10, 2005 Quote PS) I am not great at explaining what I want sometimes! you'll get no argument from me there.... I don't know excel macros, but this could be easily accomplished with perl. essentially you want it to search a row for X, if X is found in column B, then "copy" X to column A? so you will have the same value in COL A and B is that right? Quote Share this post Link to post Share on other sites
BASE813 0 #5 February 10, 2005 I really am ignorant to what perl is.............. I am quite good with Excel and VBA but rather than look the code up and change it to what I want I just wondered if someone could just give it to me! hehehehehehehehehe Not knowing perl, I will try and answer your Q - search all rows in a range for "x" and "y" when found "x" then copy "x+1" to column -1 until y then resume.................... Quote Share this post Link to post Share on other sites
Paulipod 0 #6 February 10, 2005 Happy to help if I understood exaclty your aim/purpose.... and by the sounds of it that doesnt need to be done from a seperate macro with loops at all (a simple cell formula with VBA commands / relative references in it should do maybe....) Drop me a PM if you need me! Paul Bodyflight Bedford www.bodyflight.co.uk Quote Share this post Link to post Share on other sites
