Hi, my company has customer portal that allows customer to place order that comes in as text file. I'll download the text file saved in my c drives. Then I will go to Sap customized tcode to enter the sold to, ship to, sales org and upload the text file to create sales order. Each text file has...
I'm having a vba script wherein a pdf is being generated by providing account number through input box.
I'm coping a cell value (account number), triggering the vba script through keyboard shortcut, a input box appear and now I'm supposed to paste that copied cell value into input...
Hello. I'm working on a project that requires a button click to launch an Outlook message box with a pre-filled template. I have had success with using the =hyperlink("mailto") function, but the contents of the message exceed 255 characters. I'm very novice at VBA script, and although I have...
I'm looking for a formula or vba script where i can pick numbers ending with 12,45 and 55 only on a column. Currently i use the filter to find numbers that end with these,colour them. Sort my data and delete the remaining cells on the column.
Anyone got a solution?
Thank you in...
Anyone Please give the VBA excel script for below excel formula
IF(E2=F2,"",IF(F2="",E2,IF(E2<>"",LEFT(E2&" ",30)&F2,IF(F2="","",LEFT(E2&" ",30)&F2))))
will be Much...
I'm urgently trying to automate a vlookup scenario. I have Dates in cloumns in short date format in Tab Subs Week and in Tab named Cinema-Data have Dates and 6 rows of Data in cross tab format. All I want to do is if Dates in Subsweek match Dates in Cinema-Data then I want to copy the...
^ this is the link to the macro I am working with.
Go to tab RPA and click another cell...
For some reason there is a glitch between...
I am looking for help with a scrip. A play off of the following script if possible that would copy the cell, instead of delete the row:
Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A5000").End(xlUp))
Set myCell = SrchRng.Find("Agent", LookIn:=xlValues)
If Not myCell...
I would love a VB code or something or some sort to help me with this problem, its a very important task for me. How can I find a certain text string in a PDF file (located in a certain drive) and either pull the text from the .pdf and put it in a cell, or automatically print 3 levels of...
in one sheet I have data like:
A1: Audi B1:A3
A2: BMW B2:Z300
A3: Ford B3:Fiesta
A4: Audi B4: A4
A5: Ford B5: Mondeo
in second sheet I have unique value:
Now I want to insert into second sheet in B1, B2... all value from sheet1 for Audi, Ford etc...:
B1: A3, A4...
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>Hello Excel chaps,</o:p>
I have a form that will be opened through a portal as a read only.<o:p></o:p>
As soon as all the fields are filled I want the user to press Send and then...
I have limited/no VBA experience but significant excel experience (using 2007 now). I'm trying to create an automated Goal Seek function that will automatically (upon changing of "to value", which I also need the function to seek a particular cell and not a set value) run a Goal Seek and...
I am working on a project that would generate hyperlinks to reports located in my company's local network. All reports are in the following format:
<table style="border-collapse: collapse; width: 48pt;" width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;"...