Sisu
05-24-2011, 05:15 PM
Hello again,
I am having difficulty with this challenging excel problem and thought perhaps someone may have a better view this solution. Some time ago I received help from here for the topic "conditional output to a formatted spreadsheet". I cannot thank the forum enough for its help on this but thought some may enjoy this test.
In the workbook I am trying to make a macro that "searches" another input sheet's name data (InputInvoice) and compares it to its concatenated output format (Output) where it then inserts one of either two words in a column (Paid or Unpaid) if the column on the other sheet for that name (InputInvoice) has at least one entry that is => 200. This macro will be run after I run the other macro to format the entries that already exist.
Further Description (corresponding to attached sheet):
If name on InputInvoice is the same as the concatenated version on Output,
And if Amount.InputInvoice is => 200 at least once,
Then enter "Paid" in Output.COLUMN(Z)
Where the concatenated form of Output.First+Middle and Output.Last+Suffix is the same as InputInvoice.First,Middle and InputInvoice.Last,Suffix
Else Output.COLUMN(Z) is "Unpaid";
**Note that duplicate payments can exist for each person but so long as one is greater than 200 then it is considered paid in the output.
I attached a sheet showing the desired output and examples of the inputs. If anyone would like to give it a try I would be very thankful. I will try to work on it as well and read about methods that could do this.
Thank You,
Sisu
I am having difficulty with this challenging excel problem and thought perhaps someone may have a better view this solution. Some time ago I received help from here for the topic "conditional output to a formatted spreadsheet". I cannot thank the forum enough for its help on this but thought some may enjoy this test.
In the workbook I am trying to make a macro that "searches" another input sheet's name data (InputInvoice) and compares it to its concatenated output format (Output) where it then inserts one of either two words in a column (Paid or Unpaid) if the column on the other sheet for that name (InputInvoice) has at least one entry that is => 200. This macro will be run after I run the other macro to format the entries that already exist.
Further Description (corresponding to attached sheet):
If name on InputInvoice is the same as the concatenated version on Output,
And if Amount.InputInvoice is => 200 at least once,
Then enter "Paid" in Output.COLUMN(Z)
Where the concatenated form of Output.First+Middle and Output.Last+Suffix is the same as InputInvoice.First,Middle and InputInvoice.Last,Suffix
Else Output.COLUMN(Z) is "Unpaid";
**Note that duplicate payments can exist for each person but so long as one is greater than 200 then it is considered paid in the output.
I attached a sheet showing the desired output and examples of the inputs. If anyone would like to give it a try I would be very thankful. I will try to work on it as well and read about methods that could do this.
Thank You,
Sisu