HELP ME EXCEL VBA

Hi,
I want to go to sheet2 to sheet1 by cell address. I have a cell id on sheet2 example D50 now I want to write V B A code to go sheet1 and paste amount on D10 cell . pls help me .

AttachmentSize
data entry.xlsx37.08 KB

ExcelVB Date and Filenames

I'm working with a vb macro that I use to export a sheet to pdf, then email it through outlook. I am looking to insert dates at the end of certain areas. I am able to use & Format(Date, "mm/d/yy") & to add a date to the end of my subject line. What I need now is to use something similar to add it to the end of my file name. I keep getting errors, so I'll show you the part of my code to be changed below. Let me know the simplest way to fix this with the code I already have. My goal is to end up with a file name like "Orders 12.10.15.pdf".

Sub EmailAsPDF()
ChDir "C:\Users\spec\Desktop\Orders"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\spec\Desktop\Orders\Order.pdf", OpenAfterPublish:=True
Dim OutLookApp As Object
Dim OutLookMailItem As Object
Dim myAttachments As Object

Set OutLookApp = CreateObject("Outlook.application")
Set OutLookMailItem = OutLookApp.CreateItem(0)
Set myAttachments = OutLookMailItem.Attachments

Try this

Hello,

I'm not sure I completely understand what you would like to do. But this will take the cell you currently have selected, and copy/paste that cell into D10 of sheet 1:

ActiveCell.Copy Destination:=Sheets(1).Range("D10")

Thanks to read and try to

Thanks to read and try to help me

Actually I'm owner of a short finance . I collect daily installment from customers then add their money into there accounts. I have many customers so I'm tired to fill data there accounts which was on my worksheet. so i want to make a vba with Name . Amount . Date . vba find customers name with date and fill amount his account . Can help me to coding this.

Thanks