Copy rows based on criteria

[Jack-P-Winner]

Got it Thanks Luke were GREAT!!!!!!!!

 

[Jack-P-Winner]

Question and PLEASE do not do this and let me do the grunt work LOL, I would like to enter the UD EO in 1 row and have it populate the rest of the columns so I do not have to copy and paste them all. For example, I put the EO in column F. I want it to fill in the entire column row 10-60 ..... M T AA AH AO AV BA BJ BQ BX CE CL CS CZ DG DN DU EB EI EP EW FD FK FR FY GF GM GT ...

 

[Luke M]

In cell M13
=$F13
Copy everywhere else letters are needed.

If you want some basic error checking:
=IF($F13="","",$F13)

 

[Jack-P-Winner]

Thanks Luke, will add when I get home. Error checking?

 

[Jack-P-Winner]

Now a biggie, but it loses the colors, any way to keep the red and green?

 

[Luke M]

Error checking meaning that if you don't have a value in col F, do you want other columns to display "", or are you okay if they display a 0.

To get the coloring, I'd setup some Conditional Formatting on those columns to color the cells blue/green based on cell's content. Should be fairly easy to setup.

 

[Jack-P-Winner]

I'm good with the "0". Thanks. I set up the CF. It's working great. THANK YOU!!

Can you check this out if you gave time. I'm trying yo out the date in the center column between the counters all the way down the spreadsheet.

http://forum.chandoo.org/threads/vba-to-place-date-in-several-columns.17334/

 

[Jack-P-Winner]

Luke,

I kept looking at the patterns and finally noticed what was not correct. This may sound weird but they are backwards LOL, meaning the patterns are great just the even should be odd and the odd should be even. I tried to switch them around but could not get the right pattern. Here is a picture with the same pattern but different numbers. What needs to happen is for example the first cell may say EVEN and it should say ODD maybe. Basically they are the same but they are different I need the one on the right IJKL to look like the one on the left BCDE

Thanks Luke

 

[Luke M]

Just cut and paste the columns. Aka, cut I38:I72, move it after J, and cut K38:K72 and move it after L.

 

[Jack-P-Winner]

THANKS LUKE!!!