i have workbook, where i need a macro that he finds columns with same headers, and he copies data new sheet. colomns in different order in sheets. this is my code, he works with the sheets that that have same order of columns
my macro is in private workbook
Please Login or Register to view this content.
Last edited by gogi100; 05-16-2022 at 03:11 PM.
Please post a sample workbook: instruction in yellow banner at top of page.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
i attached my workbook
i found solution with next code
but i have one more problem. when i type range A1 i receive error run-time error 13, typemismatch. and when i click on debug i go to linePlease Login or Register to view this content.
Arr = Application.Transpose(Application.Transpose(Master.Range(Master.Cells(1, 1), Master.Cells(1, LC1)).Value))
What i do?
i modified my code and this code works with range A1
but i have one more problem. if my column have blank cell. the copying does not works. my current situation isPlease Login or Register to view this content.
sheet 1, sheet 2 and allsheets. i want situation like on allsheets-1
Last edited by gogi100; 05-17-2022 at 02:00 PM.
i cannot upload pictures that i show what i want. can you help me. your button does not works
Last edited by gogi100; 05-17-2022 at 02:15 PM. Reason: edit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks