Scan through cells, and distribute to appropriate alpha sheets

**jessegpierce** · 11-28-2011, 10:21 AM

Please see this thread: http://www.excelforum.com/excel-prog...ml#post2644420

The following code goes through thousands of rows in my sheet named "source" and copies and pastes the rows throughout alphabetically named sheets like "#s", "A", "B", etc., but what if I wanted them to begin on a different column in sheet "A" like column "G"?

Please Login or Register  to view this content.

**GeneralDisarray** · 11-28-2011, 10:55 AM

please edit your post with Code tags...

Just type [ code ] before the code and [ /code ]after -- don't include the spaces between the brackets as I have.

Or, click "go advanced", highlight the code section, and click the '#" button.

**JapanDave** · 11-28-2011, 10:59 AM

I don't really understand what you want, but try this.

Please Login or Register  to view this content.

**jessegpierce** · 11-28-2011, 11:24 AM

I had played around with that myself but it doesn't work. What I'm looking for is in "source", the code goes down column B and takes the first character of the string, and copys/pastes the entire row in the appropriate alphabetic sheet (that I have already made). For instance if B2 says "Craig" then it will copy row 2 to the "C" sheet and paste it in the first available row. What I'm looking for though is for it to do all of that but instead of pasting it starting in column A in the first row, start the row in G. The row from "source" will look identical but instead of it going from Columns A to M, it would start in G and go to S.

Thanks in advance.

**JapanDave** · 11-28-2011, 11:45 AM

Click edit and put code tags around your code in your first post.

I assume you meant column G, not row G? Try this,

Please Login or Register  to view this content.

**jessegpierce** · 11-28-2011, 12:28 PM

Originally Posted by JapanDave

Click edit and put code tags around your code in your first post.

I assume you meant column G, not row G? Try this,

Please Login or Register  to view this content.

Sorry about the code tags, they have been changed.
I did mean Column G not row...
I get an object defined error with the new code. Also, I'm not sure why the code has been changed to column C in the "source" sheet because column B is where it should be looking.

**JapanDave** · 11-28-2011, 05:33 PM

Try This

Please Login or Register  to view this content.

**jessegpierce** · 11-28-2011, 06:32 PM

Can't get this to work either. Object-defined error. I had myself tried with that number 7 for the column in the code and couldn't get it to work.

**JapanDave** · 11-28-2011, 06:37 PM

This is a far as I can go without the code in a workbook to see what is happening..

**jessegpierce** · 11-28-2011, 11:36 PM

Originally Posted by JapanDave

This is a far as I can go without the code in a workbook to see what is happening..

Ok. Here is the url to download the original. The website was giving me an error when I tried to attach my .xls.
https://docs.google.com/open?id=0B3W...U5ZGZhN2M1Zjg3