Hello -
Trying to automate a manual task that's has been a pain for so long.
I receive several excel files with specific data related to some products, once I receive the excel records from customers I place them in a specific folder, these files are named in this fashion “ CustomerName_2018 Q1 – Reporting”. Then I use an excel Master file to capture some information from specific cells QTY’s and $$ Sales that are pertinent to the specific customer.
Example :
Master file -> Sheet Sales Product 1 -> Row A2 Contain "Customer 1"
when I run the code, I would like that it extracts 2 values from a closed workbook that its title contains Customer 1 and do the same thing for each customer name within column A.
The values will be taken from
Cell D26 (Customer1_2018 Q1 – Reporting) will be pasted in cell C2 (Master file)
Cell E26 will be pasted in cell D2 (Master file)
Any help will be much appreciated!
Trying to automate a manual task that's has been a pain for so long.
I receive several excel files with specific data related to some products, once I receive the excel records from customers I place them in a specific folder, these files are named in this fashion “ CustomerName_2018 Q1 – Reporting”. Then I use an excel Master file to capture some information from specific cells QTY’s and $$ Sales that are pertinent to the specific customer.
Example :
Master file -> Sheet Sales Product 1 -> Row A2 Contain "Customer 1"
when I run the code, I would like that it extracts 2 values from a closed workbook that its title contains Customer 1 and do the same thing for each customer name within column A.
The values will be taken from
Cell D26 (Customer1_2018 Q1 – Reporting) will be pasted in cell C2 (Master file)
Cell E26 will be pasted in cell D2 (Master file)
Any help will be much appreciated!