I am trying to push information from a SharePoint List on Site A to a SharePoint list on Subsite B or C. The main list has a column called "Customer URL" with the URL of the subsite the information is supposed to go to, and a column called "Customer Name" with the customers name.
I am trying to find a way to create a workflow so when a new item is added to the list on Site A, it sends the information to the list on either subsite based on the Customer name column. So once it sees it is for Customer A, it grabs the link in the Customer URL column, and sends the info to the list on that subsite. This is my problem, you can point it to a URL but you can't use variables. I can tell it to go to a URL if I type in the name, but I need it to send to a different URL each time based on the Customer Name. Please Help! :-)