Im having troubles with writing a VBA code that will copy and paste to the last row on another sheet.I do not have alot of experience with VBA coding. I am wanting to copy and paste specific cells to the other sheet in specific are of the sheet for each items. I would like to have a button that i can use to copy the information.
Thanks, Nick
LOG.pngMasterSheet.png
It is difficult to give you a precise code without seeing the workbook itself and knowing exactly what you want to copy and where to.
Attach a workbook with BEFORE and AFTER sheets to help explain what you want
(to attach a file click Reply, then Go Advanced, look below for Manage Attachments etc)
This is an example that may help
Manually select a few rows on one sheet and this code will take those rows and copy them to the next available row on SheetB using the last value in columnA to determine next row
And this copies rows 1 to 7 from SheetA to SheetB
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by kev_; 02-24-2017 at 02:44 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Originally Posted by kev_
It is difficult to give you a precise code without seeing the workbook itself and knowing exactly what you want to copy and where to.
Attach a workbook with BEFORE and AFTER sheets to help explain what you want
(to attach a file click Reply, then Go Advanced, look below for Manage Attachments etc)
This is an example that may help
Manually select a few rows on one sheet and this code will take those rows and copy them to the next available row on SheetB using the last value in columnA to determine next row
And this copies rows 1 to 7 from SheetA to SheetBPlease Login or Register to view this content.
Please Login or Register to view this content.
I would be glad to send it to you kev.
Welcome to the forum
No need to quote the previous post - just adds unnecessary clutter. Use quote tags only when you need to clarify what you are replying to.
Your file is not attached
If confidentiality is the issue just replace the text (not dates etc) with ZZZZZ
For copying and pasting all I need to know is
- what range is being copied
- where it is being pasted to
- how both of those ranges are determined (selection or some rule that VBA can apply)
- what is being pasted: formats, formulas, values etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks