So I have a work book with like 50 tabs and each tab has data in cells O5 through O20 (ex. O5 is company name and O6 is date test was performed and O7 is technician name who performed the test and O8 is result of test etc).
I want a new tab with all the data in rows like O5 becomes A1 and O6 becomes B1 and O7 becomes C1 and O8 becomes D1 etc. Would a macro do this for me? If yes can you give me an example of what code to use?
Try this. Add a new sheet and call it Summary
Open up the VBA editor by hitting ALT F11
Please Login or Register to view this content.
Insert a new module by hitting Insert - Module
Paste the macro into the empty sheet
Hit ALT F11 to get back to the worksheet.
Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
Martin
Can the macro create the new sheet named "Summary" for me when I activate it?
Try
Please Login or Register to view this content.
Cool thanks. I had just changed the word "Summary" in your code to "Sheet1" and would just hit SHIFT+F11 before running the macro and it worked great. But thanks for responding and I will remember that extra code. You are awesome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks