Skopweb
08-19-2009, 12:00 AM
Hello All
I'm looking if any script can help me to do the following task
Data is present in Sheet 1 under columns A,B,C
Column A contains data of only two categories, Apple, Oranges
The price value and quantity of the respective categories in B and C
In a Sheet2 i need the script to look for Apples and display their corresponding values present in B and C
The data should be appended in simulataneous manner (no blanks between rows)
In Sheet 3 the same should occur for Oranges
Using Excel formulas will give me the values but it will leave blanks or something else if the value in not found in the respective row.
I need to avoid those invalid or Blank rows...
Please assist
Skopweb
I'm looking if any script can help me to do the following task
Data is present in Sheet 1 under columns A,B,C
Column A contains data of only two categories, Apple, Oranges
The price value and quantity of the respective categories in B and C
In a Sheet2 i need the script to look for Apples and display their corresponding values present in B and C
The data should be appended in simulataneous manner (no blanks between rows)
In Sheet 3 the same should occur for Oranges
Using Excel formulas will give me the values but it will leave blanks or something else if the value in not found in the respective row.
I need to avoid those invalid or Blank rows...
Please assist
Skopweb