Search results

Workingfile is the one where I do the copy paste and lookup activities and paste the final output on to PDMT file on Sheet 2 i.e "Original data" Havent pasted the entire code … below is the entire code Sub Macro() Dim Workingfile As Workbook Dim PSdata As Workbook Dim PDMT As Workbook Dim...

Error while trying to activate the worksheet, am able to get the open the workbook run the lookup , however when trying to activate the same worksheet from which I have done the lookup, it throws an error as Subscript out of range <<< use code -tags >>> MsgBox ("Choose PDMT") FilePath =...

When I am declaring the variable Lrow in the entire code and initializing was giving Overflow error , so declared Lrow as Long .. its working thank you Narayan.. was really helpful

Yet there is an error.....

Option Explicit Sub macro() Dim Workingfile As Workbook Dim PDMT As Workbook Dim PSdata As Workbook Dim Commodityfile As Workbook Dim Segmentfile As Workbook Dim Lrow As Integer Dim rng As String Dim Filepath As String Dim Filepos As String Dim Filenm As String Dim Filenm1 As String Set...

Hi it’s the last line where I am receiving the error .... It’s not giving an debug option , it’s crashing out with the message ...

I know this might be a silly issue but I tried all things which I learned from here. I am receiving a Application defined error, and the Vlookup formula was working in my previous macros however this time it is a frustrating issue. well I am trying to do a vlookup between two different...

Thanks a lot... wish I could buy u a drink :)

Sorry , how to edit I dint find any option. And isn't noting to do with this code... thought this can be shirked. thanks

Hi Team, I Have an Excel Macro, however when I checked with the VBA macro it is too huge. Can the below macro be converted to VBA macro or I need to write a new one Sub Macro2() ' ' Macro2 Macro ' ' ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-1],'[PeopleSoft SPR...

Hi Team, I have a VBA macro which I have been using for sometime now, however there was an inclusion to the existing one. and I have recorded the macro for the new step however I need that in VBA and need to include in the existing macro. updating the current VBA macro and the one which I...

Thank you soo much ... :):)

Nope ... I tried the same but with normal sorting the i wont get desired output. will replicate and upload the file. thanks once again for being patience enough

To give a better understanding there are a list of suppliers in column A and I need that to be sorted from AtoZ. there is a set of data in column D which should be sorted from Tire 4 to Tire 1 and I even have blanks in them. Example : A D Supplier ABC...

Thank you so much for the quick response guys...... there is a run time error 13 while I use the above mentioned code. And I cannot upload this file :( the error is for below mentioned line : .SortFields.Add Key:=Range("D2:D12140"), SortOn:=xlSortOnValues, Order:=xlAscending...

Hi I have a MACRO recorded for a custom sort list. can I get the same in VBA coding. am pasting my macro and need the same to be in VBA coding, I was told that there will be difference in macro recording to write up the VBA code Sub sort() ' ' sort Macro ' ' Selection.AutoFilter...

and to add further I have two sets of records in the same sheet for which I need to use the same code. so here in my sheet I have the Count from M5 and count data from S5. I have updated changed the range from "C7:C" to "M5:M" . as I mentioned earlier the code is working perfectly fine, I have...

I am able to get the results when I use this code however there is a Run time error '9' and it says Subscript out of range when I searched it said if we don't specify the number of elements we get this error however in the above code ReDim is used and as per my research we shouldn't receive...

can anyone get a excel formula for the above query.... just to enhance my logical thinking in excel..

Awesome......... its works perfectly Thanks you so much

Well VBA works for me.... and the reason to use CHAR(10) is in one our application there is a function which works only if I use CHAR(10). and it is done back end. and I cannot ask to use both CHAR(13) & CHAR(10).

2010 is the version.... yes the sheet which I have uploaded is the result I am looking for

Hi, I have a daily activity which requires me to update the company names which are in separate cells into one cell based on the count. for example : if the count is two I need to combine company 1 and company 2 in one cell , like wise for count 3 and so on. the data is huge the challenge for...

Hello Sir, it is a JavaScript, am searching for a sample webpage so that it will be easy for you guys to help me , updating a rough screenshot of the webpage. so from this we require to update the name, DUNS#, details of the supplier. am not too sure if I am clear to you but this is how it is...

Well its a alert mail which is triggered from D&B site, which holds the supplier name , Duns number , amount and the status of any litigation. so on a whole I have more than 7 to 8 fields to be copied from that webpage and paste in excel.