Sub ReptRows()
Dim I As Integer, X As Integer
I = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
For X = I To 2 Step -1
ActiveSheet.Cells(X + 1, "A").Select
ActiveCell.EntireRow.Resize(50).Insert
ActiveCell.Offset(-1, 0).EntireRow.Resize(51).Select
Selection.FillDown
Next X
End Su
i have found a macro from the internet to add missing date in the data.
its not working in excel 2010. it is giving type mismatch error.
would appreciate if i get guided.
Option Explicit
Sub AddMissingDates()
'JBeaucaire (12/13/2009)
Dim LR As Long, i As Long
Application.ScreenUpdating = Fa
Hi,
I need some help in excel using Macros. I need to insert a row multiple
times.
For example
Present :
Name Place Number
Adam FL 1234
Bob AU 5678
What I need:
Name Place Number
Adam FL 1234
Adam FL 1234
Adam FL 1234
Adam
You may try this..
=SUBSTITUTE(SUBSTITUTE(B3,",,",""),", ,","")
Thx
On Tue, Apr 15, 2014 at 2:05 PM, Ashish Bhalara
wrote:
> Thanks to reply but the "Mud Flap-Vista" is a complete word, there are no
> need comma between "Mud" & "Flap-Vista".
> I want to remove only last commas, kindly suggest
I use it for a wide variety of purposes.
Sometimes I use it like a pseudo-index.
Say I have a large number of records (I routinely have lists of 90,000 rows)
and I'm attempting to report on a series of entries.
looping through these rows multiple times is very time consuming.
I used to load the r
Hi Ashish,
Thank you so much for your reply.
Just I went trhough your code , and using this code I can only able to
extract the single file at a time.
Is there any possible way to extract all the pdf's mentioned in excel sheet
in a single button click?
Regards,
Pankaj
On Thursday, April
Thanks to reply but the "Mud Flap-Vista" is a complete word, there are no
need comma between "Mud" & "Flap-Vista".
I want to remove only last commas, kindly suggest if possible.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environme
Try this =SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",")
where cell A1 contains your data..
On Tue, Apr 15, 2014 at 1:06 PM, Ashish Bhalara
wrote:
> Dear experts
>
> I have a text as per below.
> Matting, Mud Flap-Vista, , , ,,,
>
> I want remove extra comma from the end as below result b
Dear experts
I have a text as per below.
Matting, Mud Flap-Vista, , , ,,,
I want remove extra comma from the end as below result by function.
Matting, Mud Flap-Vista
Kindly suggest proper function for it.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absol
