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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copying and pasting data from 2 columns of different lengths
Hi, that wasn't exactly what I was looking for as the rows may not align in the 2 columns, but I asked a friend and found that it can be solved with a VLOOKUP and an IF function, ie VLOOKUP(D3,$A$2:$B$51,2,FALSE)in one column and IF(ISERROR(E3),F2,E3) in another column. Thanks anyway!- lioyeo
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copying and pasting data from 2 columns of different lengths
Hi, any help on vba code or formula for the following problem would be greatly appreciated: Part 1: I have 2 sets of data on the same worksheet, but the data corresponds to columns of different lengths. For example, Column E has more dates and more data than Column B. If the date in Column E...- lioyeo
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
