code to loop through column

**GuruIamnot** · 11-03-2015, 04:48 PM

hey guys,

I am not very good with VBA but learning..

I am trying to loop through a column in a document and when the word suit is found, I would like to copy and paste cell below it into another tab and continue to loop until blank row is found.

any help would be appreciated.

**alansidman** · 11-03-2015, 05:05 PM

Here is some code that copies as you specified to column A on sheet2. The original data is in column A of sheet1.

Please Login or Register  to view this content.

**GuruIamnot** · 11-03-2015, 05:09 PM

Thanks, Alansidman!

how would I be able to loop and copy cell that fall between the word "SUIT"

**alansidman** · 11-03-2015, 05:21 PM

how would I be able to loop and copy cell that fall between the word "SUIT"

I don't understand what this means.

The code I provided loops through all cells in column A until the last row. If it finds the word "Suit" it will copy the next cell below that and paste it to the next available cell in column A on sheet2. Is this what you asked for in your original thread or did I misunderstand?

**GuruIamnot** · 11-03-2015, 05:22 PM

almost perfect.

I had 2 different suites in the same document. would that also follow the same criteria?

**alansidman** · 11-03-2015, 05:23 PM

Yes, just change the word Suit in the code or build an input box asking for which word to look for and place that variable in the code.

**GuruIamnot** · 11-03-2015, 05:57 PM

Alan,

Thank you I think im beginning to understand... here is my sample worksheet. As you see its not much more indepth but.. is actually multiple SUIT items

You can see each date underneath the SUIt represents an item for that suit.. This is what I am wanting to copy and paste into its corresponding tab

**alansidman** · 11-03-2015, 06:28 PM

How is this request different from the one you posted here: http://www.excelforum.com/excel-prog...ml#post4229746 where Alf supplied you with an answer which you did not acknowledge. This appears to be a duplicate request which under the forum rules is not allowed.

**GuruIamnot** · 11-04-2015, 01:39 PM

I apologize,

I never received notification and forgot I had posted this question.

My apologies.

**alansidman** · 11-04-2015, 01:57 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

code to loop through column

LinkBack

Thread Tools

Display

code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column

Re: code to loop through column--- DUPLICATE (DO NOT RESPOND)

Re: code to loop through column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How can I make this code shorter by using a loop. or there's any easier shorcuts code

Loop through Column to find decimal then pass found row to bookmark code

Code to turn this code into a loop doing muliple copies

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

[SOLVED] Loop till end of the sheet and loop back to first column again

Code to loop through a column and change cell value based on list

Have a loop, want it to go down a column and run the same code on each row

Loop a column on Sheet1 and loop a row on Sheet2 to find a match

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions