So I'm trying to make a macro to basically copy and paste imported information and make it look pretty in the excel sheet. The imported data can change all the time, so I'm using a lot of if thens. Heres an example of my imported data:
A B C D E F
Chicago 3 3 8 7 139977-002
Chicago 7 3 7 5
Chicago 20 3 3 1
Joliet 50 3 8 6 139978-003
Joliet 150 3 8 4
Wisconsin 20 3 8 5 1339980-001
Basically, what I need to do is when there is a number in column F, I need to copy and paste the values from Column B until there is another value in F, and then to do it again all the way to the end of the data. So that the only data I copy(the first time) is 3, 7, 20, and paste that in the proper place and then next 50, 150, to paste in a different place and then next 20.
Any ideas?
A B C D E F
Chicago 3 3 8 7 139977-002
Chicago 7 3 7 5
Chicago 20 3 3 1
Joliet 50 3 8 6 139978-003
Joliet 150 3 8 4
Wisconsin 20 3 8 5 1339980-001
Basically, what I need to do is when there is a number in column F, I need to copy and paste the values from Column B until there is another value in F, and then to do it again all the way to the end of the data. So that the only data I copy(the first time) is 3, 7, 20, and paste that in the proper place and then next 50, 150, to paste in a different place and then next 20.
Any ideas?