Copy Selected Data To Others Worksheet

[jeck]

Hello,

Firstly, i want say sorry if my English language bad. Actually i'm jeck from Malaysia.
i'm beginner user for excel and trying to add some programming into selected excel file.

i have 1 excel file daily use for printing receipt.
per-day, i have printed 200x receipt using same excel (auto save to PDF and filing hard copy). Then before i go back home i must enter all detail payee,receipt no.,payment amount and 2-3 more detail per receipt to other excel file it's called "Payment Record" (for referent if needed).

i'm try to create some macros and it'e work with same excel (deferent sheet), but i don't know how to do it for auto fill in to other excel file.

this is example what i have done:-

Please Login or Register  to view this content.

i hopefully that anybody help me and teach me how to resolved this problem.
your cooperation very high value for me.

thank you.

[pike]

Hi jeck

Maybe this is what you need

Please Login or Register  to view this content.

[jeck]

Thanks pike,

i try with your code

Please Login or Register  to view this content.

but still not link to others excel.
actually i want "Official MC Receipt.xlsm" add data to "Payment Tracker.xlsm".
how can i do that?

[pike]

Hi jeck

Hi jeck
It a little unclear what you need to do
do you wish to copy between worksheets in the same workbook?

if yes you will need to change this to the worksheet where the values are keep

Please Login or Register  to view this content.

and they will be saved in the worksheet Payment Record

[jeck]

Hi Pike,

yes i wish to save to others workbook.

sorry if my explained not clear from early.

[pike]

Hi jeck


You will have to fill in "Your information" with the full workbook path and name and sheet name
try....

Please Login or Register  to view this content.

[jeck]

Pike,

It's still not working to others worksheet.
and in same excel (sheet "Payment Record") just have blank in first row.
and if i click button "add to Record" 2-3 times, still noting happen to second row.

If you see my previous code :-

Please Login or Register  to view this content.

This already work for same worksheet.
For 1st attachment i given, i just try make sheet "payment record" in same workbook for test. For real, actually sheet "Payment Record" in "Payment Tracker.xlsm" separated workbook.

apology if I trouble you...

[pike]

Hi jeck,
Can you explain exactly what happening
I think you want to loop through the values in a sheet but the values you have given dont match the workbook "V24"

Loop from workbook "a" sheet "b" range "c" to workbook "x" from sheet "y" Range "z'

[jeck]

Hi Pike,

here i attach same excel file and i already unhide all my formula
(column V in sheet"Receipt").

in file "Official MC Receipt.xlsm" have 3 sheet. 1 of them is sheet"Temp Record".
if i click add record in sheet"Receipt", all selected data will be automaticly added to sheet"temp Record" using simple code

Please Login or Register  to view this content.

what i want is, all selected data will be directly added to file "Payment Tracker.xls".

tq.

[pike]

Hi jeck
Apologies for the delay as i ve been away for the last week
first its never a good idea to merge cells
so with cells unmerged and the second workbook open

Please Login or Register  to view this content.