Posts by jethro


    Originally posted by royUK
    First suggestion would be to try recording your macros with the Macro Recorder, that way you can get an idea of what is required.

    I tought about that to, but the problem is that I don't know how to ask the user for input as to how many times the specific column should be copied.


    Are you looking to copy the complete columns, because you also mention rows?

    Well, not the entire colomn but just a the cells between row x and row y.

    Can somebody tell me how to write a macro to copy n columns from row x to row y. The "n" is to be asked for to the user. From which rows will I sort out later. I'm an absolute n00b if it comes to VBA.....

    Is the following possible?:

    In a sheet named "Index" there are links to all the other sheets in the same file, except to the sheets who start with the underscore ('_').
    I don't want to maintain all those links manually, is there a way to automate this proces?


    Originally posted by yjoshi
    This code will give you what you say you want :)

    I have tested with lot of crab data, and also encoded the checking for sheets where there is no data, so that the wrong data does not come in!!!

    Thanks, this really works great!!


    Also please avoid bringing in toooo many issues in one quote. Open different postes for different issues. This will avoid the quotes getting too bulky and confusing.

    You're right, thanks for the tip and your help!!

    Off course, no problem, i've added the sheet as an attachment.
    I've tried to explain the thing that i wanted in the "overall" sheet.
    I really hope that someone can help me out.
    Any questions are welcome.

    I finally figured out want I want exactly:

    In the range of B10:B50 I'll put a differen word on every row.
    When I click a button the script takes als the words in the range and for every word it goes to the sheet with the same name. From that sheet it copy's al the rows with text starting at row 10.
    The script pastes that text in a sheet called word_data_here starting at row 10.
    But before it starts pasting the first text the script must clear everything that is in the sheet word_data_here starting at row 10.

    Is this possible?

    I realize that the thing I'm asking is a bit complicated, the problem is that I don't know very mucht about VB and I need this script for my excelsheet to work.

    I hope that someone can help me out with this.

    I have 2 questions:
    Set cl = Sheets(Sheet2).[A65536].End(xlUp)(2) ' set paste rng

    I want the pasting to begin on the second row (for exampe), how does that work?

    Is the following possible:
    A script which copy's all the rows with text starting at row 4, but if the sheetname starts with an underscore (_), than it has to skipt that sheet.

    I'm not so familair with this VB, I know PHP quite well, but I guess I can't use that in combination with excel?


    you want to search down a column of cells and when it finds "CHRIS" you want it to bring back the cells next to "CHRIS" ?

    something like that ?

    Yes, that's want I want to use all the cells in the row where "Chris" is found.
    I can't seem to figure out how to do this with the verticallookup.
    Can you help me?

    Excuse me for my bad english....

    What I'm trying to do:
    o search trough and excelsheet for a certain value
    o when I find the value I want to use the entire row where the value is in

    If I find my value in row 2 colum B, than I want to use all the data in the entire row 2.
    Do you understand?