Hi guys.
I'm not sure if this is technically possible, but I ask you experts anyway.
I want to create a .csv file with values from 2 different sheets and a freetext.
Sheet 1 = Master
Sheet 2 = Solution
Column A in both sheets has the same information and that is my customers name.
The criteria for retrieving data is that in the Solution sheet column AN = No and the number value in column AF is greater than 0 (if the value in AF is text, then ignore)
CSV setup.
Data 1, data 2, data 3, data 4
Data 1 is located in Solution in column AF
Data 2 is a free text = Solution 1 (the same for everyone)
Data 3 is located in Solution in column A
Data 4 is located in the Master in column G
I also want to be able to name the csv file and save it under a specific folder in the code.
Let's say i want the file to be name Customers.csv for now.
Location for it to save is: C:\Golaidron\Customer
I'm not sure if this is technically possible, but I ask you experts anyway.
I want to create a .csv file with values from 2 different sheets and a freetext.
Sheet 1 = Master
Sheet 2 = Solution
Column A in both sheets has the same information and that is my customers name.
The criteria for retrieving data is that in the Solution sheet column AN = No and the number value in column AF is greater than 0 (if the value in AF is text, then ignore)
CSV setup.
Data 1, data 2, data 3, data 4
Data 1 is located in Solution in column AF
Data 2 is a free text = Solution 1 (the same for everyone)
Data 3 is located in Solution in column A
Data 4 is located in the Master in column G
I also want to be able to name the csv file and save it under a specific folder in the code.
Let's say i want the file to be name Customers.csv for now.
Location for it to save is: C:\Golaidron\Customer