| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer data from one sheet to another
Hi
I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Hi Learner
Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Ron,
Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Hi Learner,
You have added a Commandbutton from the Control Toolbox on a worksheet? Make that toolbar visible and enter the design mode (triangel icon). Right click the command button and select View Code Private Sub CommandButton1_Click() End Sub Enter between Sub and end sub the range you want to copy, e.g. Sheets("current").Range("D5:N5").Copy Sheets("database").Range("A3:K3") Exit the design mode. Wkr, JP "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
If you say database I am thinking that you want to copy the data each time below the existing data on that sheet
Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
No Ron,
Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
OK. No database then
A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
yes Ron,
now i would like to Transfer complete array to second sheet in row format. what i mean is; I have data in entry sheet from B1:K10 (total 100 data) and range("A1")=call, which i want to transfer to database sheet in row only; A1:A101 I am going to ask you more question as you helping, please ignore if i ask you silly question ( i am a leaner still) One i transfer all the data into another sheet, i want to clear the entry sheet put a button so that if range("A1")=call, it transfer all the data from database. can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
"Learner" wrote: Ron i m in a process of creating a database so that every time i fill the entry, by clicking a button all the data from entrysheet transfers database sheet. first 3 cells are the identifying cell through which i want to run a check so if they are similar it just overwrite the remaining data instead of putting into new row, So, I have data in entry sheet from A2:J11 (total 100 data) and range("A1")=Date,range"(B1")=currancy,range("C1")= profit which i want to transfer to database sheet in row only; A1:A103 (A1=date,B1=currancy, C1=profit, and range(A1:A103) all the data =range(D1:CY1) Through a Button, Once i transfer all the data into another sheet, i want to clear the entry sheet then if i enter date, currency and profit in cell A1,B1 and C1, it can fill all the remaining cell from the database can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
How do you want the cells in the row
First B1: K1 and then B2:K2 and................. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... yes Ron, now i would like to Transfer complete array to second sheet in row format. what i mean is; I have data in entry sheet from B1:K10 (total 100 data) and range("A1")=call, which i want to transfer to database sheet in row only; A1:A101 I am going to ask you more question as you helping, please ignore if i ask you silly question ( i am a leaner still) One i transfer all the data into another sheet, i want to clear the entry sheet put a button so that if range("A1")=call, it transfer all the data from database. can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Ron,
Yes if the data is diff in any of the cell A1,B1 and C1 then it transfer all the data in the seperate row. But if these three cells are same, it just overwrite all the data in database sheet. Thanks man for your time and cooperation cheers Learner "Ron de Bruin" wrote: How do you want the cells in the row First B1: K1 and then B2:K2 and................. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... yes Ron, now i would like to Transfer complete array to second sheet in row format. what i mean is; I have data in entry sheet from B1:K10 (total 100 data) and range("A1")=call, which i want to transfer to database sheet in row only; A1:A101 I am going to ask you more question as you helping, please ignore if i ask you silly question ( i am a leaner still) One i transfer all the data into another sheet, i want to clear the entry sheet put a button so that if range("A1")=call, it transfer all the data from database. can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Yes Ron,
As mentioned before if the Data in A1 B1 and C1 are same, on the transfer it just overwrite all the data. But if they are different, they past remaining data into next row. thanks man for you help cheers learner "Ron de Bruin" wrote: How do you want the cells in the row First B1: K1 and then B2:K2 and................. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... yes Ron, now i would like to Transfer complete array to second sheet in row format. what i mean is; I have data in entry sheet from B1:K10 (total 100 data) and range("A1")=call, which i want to transfer to database sheet in row only; A1:A101 I am going to ask you more question as you helping, please ignore if i ask you silly question ( i am a leaner still) One i transfer all the data into another sheet, i want to clear the entry sheet put a button so that if range("A1")=call, it transfer all the data from database. can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Transfer data from one sheet to another
Hi Learner
I think I not have my day I still not know what you exactly want Send me a small example workbook with the info I need private and I look at it this weekend. You will find my mail address on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Sorry , no time now You are the first tomorrow evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Any Updates on my previous response Ron, cheers Learner "Learner" wrote: Yes Ron, As mentioned before if the Data in A1 B1 and C1 are same, on the transfer it just overwrite all the data. But if they are different, they past remaining data into next row. thanks man for you help cheers learner "Ron de Bruin" wrote: How do you want the cells in the row First B1: K1 and then B2:K2 and................. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... yes Ron, now i would like to Transfer complete array to second sheet in row format. what i mean is; I have data in entry sheet from B1:K10 (total 100 data) and range("A1")=call, which i want to transfer to database sheet in row only; A1:A101 I am going to ask you more question as you helping, please ignore if i ask you silly question ( i am a leaner still) One i transfer all the data into another sheet, i want to clear the entry sheet put a button so that if range("A1")=call, it transfer all the data from database. can you help. thanks for your time and cooperation. Learner "Ron de Bruin" wrote: OK. No database then A one liner is OK then like JP show you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... No Ron, Data will be overwriting each time i save on the existing data. cheers "Ron de Bruin" wrote: If you say database I am thinking that you want to copy the data each time below the existing data on that sheet Am I right ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Ron, Thanks for the prompt response, I guess i am still struggling to implement the macro codes you gave me. i am going to ask you question again, and see if you can make it bit simpler what i have got is following table in worksheet1 with first row as title row. I enter data in all the remaining cells which i want to transfer into another workhseet"database" by clicking a button. column 1 column 2 column 3 column 4 row 1 RESULT 1 RESULT 2 RESULT 3 RESULT 4 row 2 33 34 35 36 row 3 45 46 47 48 row 4 68 69 70 71 let me know if you can help. thanks again "Ron de Bruin" wrote: Hi Learner Maybe you want this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Learner" wrote in message ... Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer cell data from sheet to sheet? | Excel Discussion (Misc queries) | |||
| How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
| how to transfer data from sheet to sheet with new range? | Excel Discussion (Misc queries) | |||
| How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
| How do I transfer data from 1 sheet to another? | Excel Worksheet Functions | |||
Linear Mode
