Copy date from one sheet to different Workbook

[Ramya A]

Hi,
I Have Excel File called “Workflow” Saved in Desktop
Column ‘A’ has Task ID, Column ‘B’ has Name and Column ‘C’ has Date
I want to paste each row (Column A, B & C) in different Workbooks saved In same path with the names which are in Column B.
Eg: Data in Workflow which has name as “XYZ” should paste in Workbook named as “XYZ”.
Data should not be Deleted from main workbook. Tired of doing things manually. Any help will be greatly appreciated

 

[Hany ali]

how to wait helping without Upload the Files ?!!!!

 

[Ramya A]

I am sorry i am new here i didnt understand your question.. Here is the sample file

 

[herofox]

try this
or you can to use this Code

Sub foo3()
Dim x As Workbook
Dim y As Workbook
Dim vals as Variant

'## Open both workbooks first:
Set x = Workbooks.Open(" path to copying book ")
Set y = Workbooks.Open(" path to destination book ")

'Store the value in a variable:
vals = x.Sheets("name of sheet").Range("A1").Value

'Use the variable to assign a value to the other file/sheet:
y.Sheets("sheetname").Range("A1").Value = vals

'Close x:
x.Close

End Sub

elso you can learn from this Video
How to transfer data from one workbook to another automatically using Excel VBA

 

[Ramya A]

Thank you for getting back.. My work is something tricky( as per me), I have separate workbook for each Region. I want the data from reports workbook to copied to respective region workbooks... is it something doable??