Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Hi there all
a problary most simple thing for you, im looking for a macro where t will move the data from one cell to another when i click it, thats it i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from c -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("B9" Range("A1").ClearContents End Sub -- Regards, Tom Ogilvy "cakonopka " wrote in message ... Hi there all a problary most simple thing for you, im looking for a macro where ti will move the data from one cell to another when i click it, thats it, i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from ck --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
I guess cakonopka meant "when i click the cell", didn't you ?
So is there a way to make SUBs on the events On_click in a cell ? "Tom Ogilvy" a écrit dans le message de ... Private Sub CommandButton1_Click() Range("A1").Copy Destination:=Range("B9" Range("A1").ClearContents End Sub -- Regards, Tom Ogilvy "cakonopka " wrote in message ... Hi there all a problary most simple thing for you, im looking for a macro where ti will move the data from one cell to another when i click it, thats it, i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from ck --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Tom,
would you please expalin the first row of your reply...what is Private Sub, etc.? -----Original Message----- Private Sub CommandButton1_Click() Range("A1").Copy Destination:=Range("B9" Range("A1").ClearContents End Sub -- Regards, Tom Ogilvy "cakonopka " wrote in message ... Hi there all a problary most simple thing for you, im looking for a macro where ti will move the data from one cell to another when i click it, thats it, i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from ck --- Message posted from http://www.ExcelForum.com/ . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Sub test()
Set srcSht = Sheets("Sheet1") Set tgtSht = Sheets("Sheet2") 'will copy A1 to A1... tgtSht.[a1] = srcSht.[a1] 'will copy data in column A to column C.... tgtSht.Range("C1:C" & srcSht.[a65536].End(3).Row) = _ srcSht.Range("A1:A" & srcSht.[a65536].End(3).Row).Value End Sub --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
In a previous post he said click on a button.
You can use the selectionchange event to trigger an action on cell selection, but this is usually clumsy and works whenever the cell is entered, even if not with a mouse click. -- Regards, Tom Ogilvy David wrote in message ... I guess cakonopka meant "when i click the cell", didn't you ? So is there a way to make SUBs on the events On_click in a cell ? "Tom Ogilvy" a écrit dans le message de ... Private Sub CommandButton1_Click() Range("A1").Copy Destination:=Range("B9" Range("A1").ClearContents End Sub -- Regards, Tom Ogilvy "cakonopka " wrote in message ... Hi there all a problary most simple thing for you, im looking for a macro where ti will move the data from one cell to another when i click it, thats it, i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from ck --- Message posted from http://www.ExcelForum.com/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Put a command button on the sheet and double click on it.
You will see much the same. -- Regards, Tom Ogilvy Stormin' German wrote in message ... Tom, would you please expalin the first row of your reply...what is Private Sub, etc.? -----Original Message----- Private Sub CommandButton1_Click() Range("A1").Copy Destination:=Range("B9" Range("A1").ClearContents End Sub -- Regards, Tom Ogilvy "cakonopka " wrote in message ... Hi there all a problary most simple thing for you, im looking for a macro where ti will move the data from one cell to another when i click it, thats it, i know there is problary some simple thing but i dont know it, lol. if u cant do it please let me know so i can stop trying, lol cheers from ck --- Message posted from http://www.ExcelForum.com/ . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Hi there
yep u were right i did want ti when i clicka button i will try it an see if ti works ok if i need any more ill get back to you all, an cheers again very much t you all for your help. Cheers From C -- Message posted from http://www.ExcelForum.com |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that copies that data from one cell on one sheet to a cell on another?
Hi ther all
that ahs worked great but i need to add a bit to it so that once i have clicked the button and it has moved all of the data it iserts a new row above, lol, any idea on this anyone, that way each time new data is entered the rest is moved down and the new data is at the top of the list, lol, if u know what i mean. cheers from CK This is all very much appreciated, thats everyone so much --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
macro which copies data from a 2nd WB, The WB has a new name each | Excel Discussion (Misc queries) | |||
Type in one cell and data copies into another cell | Excel Discussion (Misc queries) | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
Keyboard Macro Just Copies Content of Previous Cell | Excel Discussion (Misc queries) |