Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to copy data from multiple column to single column
Hi, Sorry for the confusion. I will clarify here. I have an Excel worksheet like this: A B C D E F G 1 1a 1b 1c 1d 1e - 2 1e - 1a 1f 1b 1d 3 1c 1b 1f - 1d 1e From that I want a new worksheet like below: A B C D E F G 1 1a 1b 1c 1d 1e - 2 1a 1b - 1d 1e 1f 3 - 1b 1c 1d 1e 1f Total 2 3 2 3 3 2...- harini123
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to copy data from multiple column to single column
Hi, I have an Excel worksheet, which is having some 100 rows of data. Each row / line has a same data but in different cell for example B4, C8, D15 & F20 all has same data say "John" like that. Now I want to copy all "John" to Column A2, A3, A4, etc. in a new worksheet. In...- harini123
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
