Search results for query: *

Awesome! Thanks for the help. This make it very easy. Chumo82

Actually I just found a simple solution on another forum. It doesn't even use vba so it can do for now. This is what I have found so far and it seemed to work pretty well. If you have entered range from A2 to A500, then select them and Do this... 1. Press F5 (go to) 2. Select blanks and press...

Last row is determine by other columns of data. I kinda dumbed it down a little but I could live with having to manually put the last couple of entries in myself just not all 20000. I hope this helps better explain. Chumo82

I was looking for a way either using straight excel or vba to populate blanks in a column with the information above. I need it for about 20000 records and it would be tedious to just keep copying and pasting. I hope this diagram better explains what I am looking to do. Before: 1 6543212 2...

I figured it out. Your code was perfect I was just being stupid and didn't change cell ranges. Thank You for the help. :)

I tried this but it does not appear to display the value in the worksheet I need it in. At first I thought it was just backwards but when I try different things I never get an output. Maybe I am missing something (unfortunately I am just learning VBA). Is there a way other than this to place...

Ok, here is my problem… I am trying to copy from a single cell from worksheet1 and place it in a merged cell in worksheet2. I don’t want to have the borders copy over just the values but I always get error about the cells not being the right size. I have also tried PasteSpecial and have it...