thank you so much that's brilliant!
On Wednesday, 14 May 2014 04:36:45 UTC+1, Vicky wrote:
>
> Hello Wendy,
>
> See attached UDF to separate alpha numeric characters with dash (-).
>
> Regards,
>
>
> On Wed, May 14, 2014 at 1:18 AM, Wendy Beckett
>
> > wrote:
>
>> Don't know if anyone can help
try this code
Sub Macro1()
Dim i As Date, j As Long
Application.ScreenUpdating = False
For i = DateSerial(2013, 1, 1) To DateSerial(2013, 1, 10) ' change start
date and end date
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;
http://www.wunderground.com/weatherstation/WXDailyH
Hello Wendy,
See attached UDF to separate alpha numeric characters with dash (-).
Regards,
On Wed, May 14, 2014 at 1:18 AM, Wendy Beckett wrote:
> Don't know if anyone can help me but I am trying to format cell contents
> that are a combination of numbers and text. I would like the cell conten
I believe there's no way of doing this with custom format. If the text
always has that structure (3 letters followed by 4 numbers) you can use
text formulas to create the text you want:
=LEFT(A1, 3)&"-"&RIGHT(A1, 4)
On Tuesday, May 13, 2014 3:48:20 PM UTC-4, Wendy Beckett wrote:
>
> Don't know
Don't know if anyone can help me but I am trying to format cell contents
that are a combination of numbers and text. I would like the cell content
Jan1324 to display as Jan-1324 is there any way I can use the custom format
to do this? Any help appreciated its been driving me mad all day!! Thank
hi looking forward to finding out lots more about Excel. I am an ILT
developer and work in an FE college supporting staff and students in all
areas of Microsoft Office and technology in teaching and learning.
On Friday, 8 June 2012 20:21:59 UTC+1, Ayush Jain wrote:
>
> Hey all new and current po
Hi Guys! Everyone is welcome.
Here's the website for a Personal Weather Station in London:
http://www.wunderground.com/personal-weather-station/dashboard?ID=IBUCKSIV1#history/data/s20100101/e20140513/mcustom
It features a option to produce CSV data of any single day, in intervals of
5 minutes.
>
> Hi All!
>
I am Franklin Zolf, data science phd, working on excel as a bridge to
legacy in distributed systems.
All my work is in data migration onto platforms for analysis and get-stun.
I lasted worked with Excel in 2014 and am now getting back into it.
We can help each other! I hope to
Hi
Try this: Enter sheet name in Row A2 to A10
Sub AddSheets()Dim cell As Excel.RangeDim wsWithSheetNames As
Excel.WorksheetDim wbToAddSheetsTo As Excel.Workbook
Set wsWithSheetNames = ActiveSheetSet wbToAddSheetsTo =
ActiveWorkbookFor Each cell In wsWithSheetNames.Range("A2:A10") '
Change ra
I need a macro where if i enter a data in the column of first worksheet i
want those to be the names of another worksheets accordingly.
please kindly help me
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this f
Hi, please download VBA Interview Questions from below link
http://excelvbasupport.com/forum/showthread.php?tid=64
Thanks & Regards
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.faceb
Please download VBA EBOOK from below link
http://excelvbasupport.com/forum/showthread.php?tid=66&pid=144#pid144
On Mon, May 12, 2014 at 12:46 PM, Renukachari Kasee wrote:
> Dear Group,
>
>
> any one please provide the ebook for excel macros
>
> i.e. 101 READY-TO-USE EXCEL MACROS by Michael Ale
Yes by using calculated Item.
On Tue, May 13, 2014 at 11:16 AM, Amit Desai (MERU) wrote:
> Hi
>
>
>
> Does this also work on column containing Non-Numeric data?
>
>
>
> Regards,
>
> *Amit*
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vaibh
Thank you very much :)
On Tue, May 13, 2014 at 11:16 AM, Amit Desai (MERU) wrote:
> Hi
>
>
>
> Does this also work on column containing Non-Numeric data?
>
>
>
> Regards,
>
> *Amit*
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi
Dear Vabz
It can be moved by a button.
On Tuesday, May 13, 2014 12:35:15 PM UTC+5:30, Vabz wrote:
>
> what is trigger for moving?
>
>
> On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal
> > wrote:
>
>> Dear Friends,
>>
>> I would like to update the data from sheet viz. "Sales Register" to the
>>
what is trigger for moving?
On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal wrote:
> Dear Friends,
>
> I would like to update the data from sheet viz. "Sales Register" to the
> next three sheets as per column "Invoice No."
>
> For Example: Invoice No. starts from: "CPU2014-15-XXX" should move t
16 matches
Mail list logo
