Hi Marvin,
Thank you for your response! I studied your formula carefully and it's similar to what I had originally before posting:
=IF(InputSheet!J2="Business Address", InvoiceRaw!K2, "")
Perhaps I should explain better or I am not fully understanding the logic, but it appears that both the above (mine) and below (yours)
=IF('InputSheet (copy-pasted in)'!$J$2="Business Address",'InputSheet (copy-pasted in)'!P2,IF('InputSheet (copy-pasted in)'!$J$2="Home Address",'InputSheet (copy-pasted in)'!P2,""))
do not organize the new output in the columns WorkAddress1, WorkAddress2... based on the value of the type column being Business Address nor in HomeAddress1, HomeAddress2 based on the value of the type column being Home Address. As it currently is, all outputs are "transferred" without respect to where they are being tranferred to. Unless of course I am missing something...
This user on a different forum appeared to have the same problem (perhaps he's also using the same software I'm using with this ) and made very rough tables showing how the output address in the columns should correspond to their types:
"NOW:
PRIMARY
1|Business Address | 123 Grove St. | New York | NY | 01011 | USA
2|Home Address | 654 Oak St. | Boston | MA | 32456 | USA
3|Business Address | 81 Main St. | Seattle | WA | 14643 | USA
4|Business Address | 987 West St. | Miami | FL | 69434 | USA
5|Business Address | 534 East St. | Miami | FL | 69432 | USA
6|Business Address | 1 GM. Rd. | Detroit | MI | 85345 | USA
SECONDARY
1| | | | | |
2|Business Address | 945 Smith St.| Boston | MA | 32456 | USA
3|Home Address | 12 Tree Rd. | Tacoma | WA | 14641 | USA
4|
5|
6|Home Address | 97 Key St. | Detroit | MI | 04232 | USA
HOW IT SHOULD LOOK:
BUSINESS
1|Business Address| 123 Grove st. etc.
2|Business Address| 945 Smith St. etc.
3|Business Address| 81 Main St. etc...
4| Business Address| 987 West St. etc.....
HOME
1| | | | | (Blank)
2| Home Address| 654 Oak St. etc.
3| Home Address | 12 Tree Rd. etc.
4| |||||(Blank)
5| (Blank)
6| Home Address| 97 Key St. etc."
In this case it also looks like he has a secondary set of addresses he's trying to compare to the first and determine the output based on type. I am not so certain, but I believe this is the reason VBA is needed as it can compare more than one cell i.e. work v. home at once.
Thank You,
Sisu
Bookmarks