I'm certain this comes up a lot but I couldn't find a similar issue in the forums so I apologize if this duplicates someone's efforts.
I am relatively new to Excel but I am getting a baptism by fire. I have a spreadsheet that tracks equipment that is put on trucks. Column B contains all of the vehicle information in 10 cells (B1:B10)(B11:B20) This repeats 10 cells at a time for 6000 or so rows. I am trying to copy the information from the worksheet into another but transpose it into a series of rows (A1:J1)(A2:J2) etc.
Can someone help me with a macro or VB code that would automate this process? I am happy to offer semi-truck rides or time in really big tractors to anyone who can help.
Thanks in advance.
Andy
Bookmarks