I need help with the last (pasting) part of a macro. For simplicity's sake, the macro copies a range of data based on the column heading (in row 1), then opens the workbook in which to paste it. I need the final step, which is to locate the same column heading that it copied from (again in row 1) and paste the data beneath it. Any suggestions? I used "UCase(strVal) = UCase(strColName)" to locate the correct column name for copying. Thanks.
HrSwirly 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.