Chirag R Raval
Member
Dear Sir,
Subject :- Vba Code help Require -Lookup for Cell A2's value-In Another File-In Column "A" -GET Column "B" ' S VALUE As Result ..which become Current File's Save As Name ..
I have multi file to save as via vba code.
New file Added (Generated) as process of running VBA code ..
(code will be generate many files)
newly created file's cell "A2" has Buyer Number..
need to save this newly created file as this "A2"'s buyer number's Name which found on another Buyer Master file on Column "B" (Buyer Master's Number column (Lookup Columns) is same .."A"
Need to code that vlookup (Hidden Mode, Closed file-without open buyer master) on search for this file's A2's value in another file...in Columns "A" & get B2's Value (name) ...so I can make this result as New File Save As name.
Can anyone help regarding this situation?
Regards,
Chirag Raval
Subject :- Vba Code help Require -Lookup for Cell A2's value-In Another File-In Column "A" -GET Column "B" ' S VALUE As Result ..which become Current File's Save As Name ..
I have multi file to save as via vba code.
New file Added (Generated) as process of running VBA code ..
(code will be generate many files)
newly created file's cell "A2" has Buyer Number..
need to save this newly created file as this "A2"'s buyer number's Name which found on another Buyer Master file on Column "B" (Buyer Master's Number column (Lookup Columns) is same .."A"
Need to code that vlookup (Hidden Mode, Closed file-without open buyer master) on search for this file's A2's value in another file...in Columns "A" & get B2's Value (name) ...so I can make this result as New File Save As name.
Can anyone help regarding this situation?
Regards,
Chirag Raval
Last edited: