Copying data from workbook to workbook using button
Solved/Closed
Related:
- Copying data from workbook to workbook using button
- At button - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to answer call with volume button android - Guide
- New outlook refresh button - Guide
1 response
OK, well here is the code.
We do not provide turn key solutions. Tweek this simple code to do the real details of what you are asking. Use the below cut and paste as a wireframe, and modify it to fit your needs!
All I did was record a macro, now just tweek it to fit your needs!
We do not provide turn key solutions. Tweek this simple code to do the real details of what you are asking. Use the below cut and paste as a wireframe, and modify it to fit your needs!
Sub copytoanewfile()
'
' copytoanewfile Macro
' Macro recorded 9/29/2015 by onebaddass mf'r
'
'
Range("B2:B8").Select
Selection.Copy
Workbooks.Open Filename:= _
"C:\here_is_the\filepath\and-the\filename.xls"
Range("B23").Select
ActiveSheet.Paste
End Sub
All I did was record a macro, now just tweek it to fit your needs!
Sep 30, 2015 at 08:55 AM
But I can't invent how to write a command to save and close active worksheet.
Any ideas?
Sep 30, 2015 at 04:57 PM
or
Oct 7, 2015 at 06:09 PM