Macros, button that copies data from certain cells into table
Closed
Bex
-
May 10, 2015 at 03:10 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 11, 2015 at 05:25 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 11, 2015 at 05:25 AM
Related:
- Macros, button that copies data from certain cells into table
- At button - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Macros in excel download - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.