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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.