Transfer data from one sheet to another

L

Learner

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
 
L

Learner

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
 
J

JP Ronse

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
 
L

Learner

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
 
L

Learner

Learner said:
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
Click to expand...
(A1=date,B1=currancy, C1=profit, and range(A1:A103) all the data
=range(D1:CY1)
 
L

Learner

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
 
L

Learner

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
 
R

Ron de Bruin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
Construct table from selected rows 4
how to apply the code to the whole of the worksheet? 1
Copy Array to Array, how to and should I? 13
Add additional information to excel form after original data entry 0
switch to another worksheet, then return to original sheet 2
export excel data to access table using ADO 0
Copy specific cells to another tab 6

Top