Macros, button that copies data from certain cells into table
Closed
Bex
-
May 10, 2015 at 03:10 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 11, 2015 at 05:25 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 11, 2015 at 05:25 AM
Related:
- Macros, button that copies data from certain cells into table
- At button - Guide
- Tmobile data check - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Transfer data from one excel worksheet to another automatically - Guide
- New outlook refresh button - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
May 11, 2015 at 05:25 AM
May 11, 2015 at 05:25 AM
Hello Bex,
You'd best upload a sample of your work book so that we can see exactly what it is that you want to do. The following basic code will copy random cells from sheet 1 to sheet 2:-
but it will only place them one beneath the next in sheet 2.
Do you have an entire row of data to transfer over with the random cell value?
You can upload a sample of your work book using a free file sharing site such as DropBox or ge.tt
Cheerio,
vcoolio.
You'd best upload a sample of your work book so that we can see exactly what it is that you want to do. The following basic code will copy random cells from sheet 1 to sheet 2:-
Sub CopyValues()
Application.ScreenUpdating = False
ActiveCell.Copy
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
Application.ScreenUpdating = True
Application.CutCopyMode = False
Sheets("Sheet2").Select
End Sub
but it will only place them one beneath the next in sheet 2.
Do you have an entire row of data to transfer over with the random cell value?
You can upload a sample of your work book using a free file sharing site such as DropBox or ge.tt
Cheerio,
vcoolio.
