I have a workbook called Steve Simons which I would like help building a macro that would help the agent fill out an online form. With this workbook, I would to have the ability to put in the date, the SP# & CID then if column H has a 1 in it (only the last row that has the 1 in column H), I want this script to run.
This code opens an internal webpage which I would like for the information that is on the spreadsheet to relay over to that online form.
Status of Case = "Triage - OE"
Owning Business = "Kill / Rebook"
Status Date / Time Change = Current date & time
Status Changed By = "Steve Simons"
(The next 6 input fields would be blank"
Agent Reporting Issue = "Steve Simons"
Super User Reporting Issue = "Steve Simons"
Customer # = cell value of column C
Date Resolution Needed = Current date & Time
Number of Customer Calls = "1"
Then everything else can be blank.
For some reason I can not submit the HTML code to show you the code however I did add a picture of my site. Please send me a message if you are able to assist & I will be more than happy to send you the HTML code that has this webpage. I have attached the workbook for any assistance that you can provide along with the picture from the internal website to help understand what it looks like & your help is always greatly appreciated!
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks