DATA FILE PREPARATION

[Vickytayade18]

Hi All helpful people,
good day!!


I have 3 file:
1. Output file : In which i want data from ref file. (from cell B4)
2. Input file: in which only input data is give, which is to be filled in Output file.
3. Ref file: from which data is to be fetched in Output file. (within the green highlighted columns.)

I have added one line manually in output file as a reference output.

Please help me to build a code to match my requirements, Please do the needful.
attached files.

 

[MikeTE]

hiya,

did you tried recording macro?
(sorry I don't know how to paste code properly here)
then if you create new file with the same name, macro will pull info from this file

>>> use code - tags <<<
​

Sub pull_data()
'
' pull_data Macro
'
'
    Workbooks.Open Filename:= _
        "your directory+file name and extention"
    ActiveWindow.ScrollColumn = 2
    Cells.Select
    Selection.Copy
    Windows("TOOL.xlsm").Activate
    Cells.Select
    ActiveSheet.Paste
End Sub

 

[Vickytayade18]

THANKS FOR THE RESPONSE, BUT THIS CODE IS WORKING BUDDY.