Search results

Hi all, I have a data set of 500 rows. trying to add two blank rows after every record through VBA. Can u plz get me the code? Kaushik

Hi Nicki, Welcome to the forum and we glad to have u here. Could you plz upload your sample data here? http://chandoo.org/forums/topic/posting-a-sample-workbook Regards, Kaushik

Hello all, Can someone plz reply on this and help me to get it corrected? Kaushik

Hello experts, Just got stuck in some other works and could not follow this up. Sorry!! Here is the sample workbook. http://speedy.sh/3zGGQ/Myalert.xlsm The "My New Worksheet" of the sample workbook contains data (colored) which is generated from a raw data(which I have not given here)...

Yes...I completely agree with Narayan.. Kaushik

Suresh, Uploading the workbook would definitely help. However, I have quick question here. It looks like B1 , C1 and AB1, AC1 have some values already entered. Once you copy the formula from A1, and paste it in AA1, it will take the reference of AB1 AND AC1 provided,Col B is not fixed...

Hi suresh, Are u trying to compare the cell reference in text format? Say your data is as follows from A1 to B2: A3 AA3 A4 A4 At C1 try this: =IF(LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)<>LEFT(B1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},B1),""))-1),"Ok to...

Hi Guna, I am little confused by looking at the data set you have posted. ColA ColB ColC X1/a b X2/a X3/c d X4/b X1/b X2/a b X4/d X1/b c X2/c bX3/c According to your post, you are expecting "present" (as the result) when you search "x2/b" in Col B row2.But in Col B...

Hello ahhhmed, Please download the workbook from the below link: http://speedy.sh/4m4t7/A-to-Z-data.xlsm At the last row of the Column A of sheet1, if you enter any letter and press enter, the macro will automatically run and arrange the data in alphabetical order. The main subroutine is...

Same way: =IF(G14="","",IF(G14>60,"Late","Early")) Kaushik

Hi Sachin, I believe this is the problem similar to your last post which was solved yesterday. Could you plz upload your workbooks with the code in it? Kaushik

Glad that your problem is solved.

Hi George, May I know what is reson you want to achieve this without using WorksheetFunction? Assuming your data ranges from A1 to A11 as follows: Header1 1 2 3 4 5 6 7 8 9 10 The below code will give you the sum of the above values at the last available cell(in this case, you...

Glad to hear that you have solved it...

Hi Sachin, Try this: ActiveCell.Value = Application.WorksheetFunction.VLookup(Range("b" & (myval)).Value, Workbooks("workbook name").Worksheets("data").Range("e:cl"), 86, 0) Note: Make sure the workbook, from where you are fetching the data, is open. Kaushik

Miss you Pablo sir..

Hi crack100, Your problem is not clear to me. Could you please answer my below questions? 1)According to your post, user has the provision to update dates in "Date Source" tab. Could you please tell us which cloumn (of "Date Source" tab) user could do so? 2)You want the drop down cell...

You are welcome Sachin....Let me know if it was fine. Kaushik

Hi Sachin, Try this, Sub MyVlookUp() Dim MyVal As Integer Dim LstRow As Long LstRow = Sheet2.Range("A" & Rows.Count).End(xlUp).Row Sheet2.Activate For MyVal = 2 To LstRow On Error Resume Next Range("B" & (MyVal)).Value =...

Hi all, I have automated a daily report (which earlier involves some sort manual work) by which user would be able to send(through e-mail) the report to all the intended recipients on click of a button. In addition to my code, I have taken the reference of Ron's code to send the report...

mohanyathish, When I read the first half of your post, things were very clear to me. But when I read your expected result part, I got little confused. According to me the top 3 result should be: "Mary" is a wonderful name. 15 Mark was killed in an accident 12 Mark and Mary work together...

Hi jonhowlett, Welcome to the forum. I am not able to download your file due to firewall policy, but looks like you are looking for something like this: http://datapigtechnologies.com/blog/index.php/suppressing-zeros-in-chart-labels/ Kaushik

Hi Vishup, Hope you are doing great. Regarding your next requirement (deleting rows with lower subsequent number(s) for the duplicate IDs), we can certainly achieve that by VBA. If you want to delete rows (at one go) based on some conditions(s), only formula will not help you. But I am not...

Hi Vishup, Welcome to the forum. Assuming your data spreads across as below: Col (A) Col (B) Emp Code Value 110 2 110 1 111 3 111 2 113 4 113 5 111 8 Now, the formula to get the higher sequence number from...

Hi Vijay, If I understand your question properly, then you are trying to find out out the last blank row in a sheet where you are trying to paste the data. If I am correct, then let's take the below example: In sheet1, say A1 to A8 are already filled with data. Now your filtered data...