• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DATA FILE PREPARATION

Vickytayade18

New Member
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.
 

Attachments

MikeTE

New Member
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 <<<
Code:
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
 
Last edited by a moderator:
Top