NameDateSpot Name Unique Identifier License Number
SDF, Inc. 7/22/16 5:15VGT 01 330615 501031
SDF, Inc. 7/22/16 5:15VGT 02 330616 501032
SDF, Inc. 7/22/16 5:15VGT 03 2081877 505021
SDF, Inc. 7/22/16 5:15VGT 04 2084750
Show me the new output for the new format.
Regards
Mandeep baluja
On Tuesday, 26 July 2016 02:22:13 UTC+5:30, Mike B wrote:
>
> Hi All,
>
> Please find an updated workbook with three worksheets which show the "New
> Format" of data the "Old Format" of data and what the "Data Should Look
> Like"
Hi Mandeep,
You helped me over a year ago with this macro; however they changed the
formatting of the data and now are not using the word “Establishment” before
the company name and are also not using the word “Accounting Period Start Date
:” before the actual date and time; can you help to re
t;
> Mike
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mandeep baluja
> *Sent:* Monday, March 16, 2015 11:35 PM
> *To:* excel-...@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: vba recorded macro not working
&
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: vba recorded macro not working
Dear Mike,
Thank u so much for your Appreciation. It's a pleasure to help anyone because
it expands my knowledge about VBA , The thing is I am a beginner and wish i
will reach at a position where
] On
Behalf Of Mandeep baluja
Sent: Monday, March 16, 2015 11:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: vba recorded macro not working
Dear Mike,
Thank u so much for your Appreciation. It's a pleasure to help anyone because
it expands my knowledge about VBA
gt;
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mandeep baluja
> *Sent:* Monday, March 16, 2015 4:48 AM
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: vba recorded macro not working
>
>
>
> Run this co
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep baluja
Sent: Monday, March 16, 2015 4:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: vba recorded macro not working
Run this code in your data
Sub Test()
With Application
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
Set Rng = Range("C1:C" & lr)
Debug.Print Rng.Address
For Each Cell In Rng
If Left(Cell.Value, 5) = "Estab" Then
esta
Hi Mandeep,
I would appreciate you looking at the attached worksheet, I have written
and explanation in a comment on the worksheet explaining the issues I am
experiencing, I thought it would be easier for you to understand.
On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote:
> Thank yo
Thank you, thank you so much for all your help and quick response!! I am
going to have to study my books to understand your code fully, it is so
precise and quick. Thank you again, Mandeep!
On Thursday, March 5, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
>
> I try it works but goes back to w
it's so easy paste this code in module. i have highlighted the line in bold
where change is done. Remember one thing once these lines will be deleted
it can traverse back.
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells
Hi Mandeep,
Than you very, very much your macro works great, saving me an enormous
amount of time. I would like to ask you one more thing , would you be able
to add code to now delete the two rows containing the two dates, Totals for
*Totals
for 12/11/2014 5:15:14 AM:* and *12/12/2014 5:15. Tha
Hello mike, Please find the attached file as per your requirement. Always
send your requirement output in excel file.
Regards,
Mandeep Baluja
On Saturday, March 7, 2015 at 7:33:44 AM UTC+5:30, Mike B wrote:
>
>*12/11/2014 5:15**12/11/2014 5:15*CGT 01*12/11/2014
> 5:15*CGT 0
*12/11/2014 5:15**12/11/2014 5:15*CGT 01*12/11/2014
5:15*CGT 02*12/11/2014 5:15*CGT 03*Totals for 12/11/2014 5:15:14
AM:**12/12/2014
5:15*CGT 01CGT 02
CGT 03
Thank you Mandeep for helping. I have very large file 7,800 rows of data,
in Column "C" I have dates in December
send me your file and steps you want to achieve
Regards,
Mandeep
On Thursday, March 5, 2015 at 9:46:12 PM UTC+5:30, Mike B wrote:
>
>
>
> I try it works but goes back to what I just did even though I moved my
> cursor down 11 rows. I would appreciate any help how to get it to advance
> to the n
16 matches
Mail list logo
