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