Hi guys,
as the title suggests, i need a macro that copies everything from column B through to the last column of data, pastes to first empty column on the "summary" worksheet and repeats for next worksheet until complete! can't get it to work!
Hi guys,
as the title suggests, i need a macro that copies everything from column B through to the last column of data, pastes to first empty column on the "summary" worksheet and repeats for next worksheet until complete! can't get it to work!
Last edited by fabrecass; 02-12-2013 at 04:31 AM.
Hi fabrecass,
Maybe something like the attached sample WorkBook?![]()
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon, a little bit like this yes, but this seems to copy column A also? and I'd like the data pasted horizontally (first blank column) rather than vertically?
Last edited by fabrecass; 02-11-2013 at 05:43 AM.
I've been playing with this code trying to get it to paste to the first blank column on the "summary" worksheet, but it just pastes over what is already there...!![]()
Please Login or Register to view this content.
can anyone help?!
Hi fabrecass,
I have changed the WorkBook, but it still copies the data vertically, as you will see in the attached WorkBook.
Could you please add another Sheet as a sample and upload the WorkBook, of how you would like the data to be displayed, since I believe by Transposing it could lead to confusion.
I wish i could Winon.
work restrictions mean that i'm unable to upload a sample work book.
Basically it's a form.
column A is filled with questions
columns B, C, D etc are individual records.
I need the individual records lined up side by side on a separate sheet.
i don't want to copy column A from each worksheet because i only need the data of the individual records.
does this help?
We don't need the actual original WorkBook.work restrictions mean that i'm unable to upload a sample work book.
Make up a simple Sample WorkBook, with all the relevant code, Forms and other controls included, and upload that for us.
Hi Winon! sorry i wasn't clear! i'm unable to upload ANYTHING, internet restrictions i'm afraid!
i appreciate this makes it terribly difficult.
whey! it seems to have worked. please see example attached Winon!
can anyone help? example file above. I need each master sheet pasted to the summary sheet, but horizontally NOT vertically!
this code works vertically, i just can't amend it so it pastes horizontally!
![]()
Please Login or Register to view this content.
no one can help?!
I have recorded a macro, assuming your DataSheets and Columns will be constant, and the attached WorkBook, shows the result if you click on the Update Button on the Summary Sheet.
Sorry, but that is the best I could come up with, for now!![]()
Thank you Winon, very nearly perfect!
Hi fabrecass,
You are welcome.
Thank you for the feedback.
Your DataSheets and Columns no longer need to be constant, and the attached WorkBook shows the result if you click on the Update Button on the Summary Sheet. Even if you add or remove Columns in the Master(89) or Master(90) Sheets, the Code should be able to handle that as well!![]()
Hi fabrecass,
Oops, I completely forgot that you wanted to copy from Column B. It is now corrected in the attached WorkBook.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks