Hi Kevin,
You've only provided one sample set of data. If we want to automate this, then
we need to know if every set of data
is exactly as shown in the sample.
eg: is each set of data always 3 rows, always 3 columns, always a blank cell on
the second row of the Name/Company column, always a bl
Totally agree, If excel has the feature, that it automatically checks,
whichever cell has been changed, should be spell checked.
But at the same time, it should have the feature to also disable it,
because, Excel is used for a wide variety of Data Mining things, and
if the feature cannot be diable
Hi Admins' ( I mean all the people who are running the show),
I think its a great thought to formulise or standardise a way question
is asked. As i have also experienced, and reading the thoughts of
Paul, Ayush and Surya.etc, i also vet a similar thought that it
becomes increasingly difficult
Hi All,
My excel containd the following rows and columns:
I want to convert this data into an xml file based on the path mentioned in the
2nd column
Data
Path
Name
ocim:root/ocim:name[xsi type:"myname"]/ocim:firstname
Name2
ocim:root/ocim:name[xsi type:"myname"]/ocim:Lastname
i doubt "
Hi Paul,
Thanks for the suggestion. I will try your code as soon and maybe pick-up
from there.
To show my appreciation, perhaps when your are traveling to Philippines, I
can drive you around. I will be off from work then.
On Thu, Apr 15, 2010 at 8:12 PM, Paul Schreiner wrote:
> WAY too much
Dear Group,
I'm trying to extract a data from another workbook to another workbook. I
created this macro but it gives me an OUT of range error.
Please help.
Sub Bankreport()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Set rd = Workbooks("C
Sorry Paul, to bother you again.
Everything was working fine till I sorted the worksheets. Now I am
getting an error message "Run Time Error :1004" .(The sort reference
is not valid. Make sure that it is within the data you want to
sort,and the first sort by box isn't the same or blank) Please he
Hi there,
I hope this is enough...
On Thu, Apr 15, 2010 at 9:13 PM, Dave Bonallack
wrote:
> Hi,
> This sort of data can usually be "cleaned up" automatically.
> You will need to attach a workbook that contains a few addresses in their
> current form, and at least one address in the format you'
-- Forwarded message --
From: Yahya
Date: Fri, Apr 16, 2010 at 10:07 PM
Subject: Re: $$Excel-Macros$$ Refresh Autofilter Automatically
To: chreiner_p...@att.net
Sorry Paul, to bother you again.
Everything was working fine till I sorted the worksheets. Now I am getting
an error
Hello! This website is a wonderful resource! Thank you so much for
it.
I have been slowly learning VBA on my own and often read through code
to try to learn.
My question concerns the sample provided by Shyam on March 30,
"Extract Number FROM
Alphanumeric String".
The function works wonderfully
Well put. I agree.
Dave.
Date: Fri, 16 Apr 2010 10:45:13 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Understanding & Implementation
To: excel-macros@googlegroups.com
Ayush (and all)
I think that it's important for new members (and anyone else requesting
assistance
Ayush (and all)
I think that it's important for new members (and anyone else requesting
assistance)
to recognize that WE don't work for Microsoft.
And WE have paying jobs (sometimes) not related to this user group!
Many times, (probably most) we use VBA 8-12 hours per day
and participate in the
I used your code and it solved both problems - thanks, Paul!!
On Fri, Apr 16, 2010 at 10:38 AM, Paul Schreiner wrote:
> either try my suggested code (which may solve both problems)
> or try making sure the proper sheet is selected by using:
>
> sheets("sheet1").Select
> (insert appropriate sheet
Any More inputs on this ?
Come on groupPlease share :)
On Apr 12, 1:40 pm, Anand Desai wrote:
> Abhishek,
>
> I know about spellcheck feature. red-underlines are useful and time saving..
>
> Anand
>
> On Mon, Apr 12, 2010 at 1:20 PM, Abhishek Jain wrote:
>
> > I think it is available.The onl
Hi surya,
Relay nice analysis and aware of these mails
Thanks for u r advice,
Nike
On Fri, Apr 16, 2010 at 8:35 PM, Ayush wrote:
> Dear Surya,
> I welcome your valuable feedback. The group is really doing well.
>
> Dear members,
> I agree with Surya's advice. We are here to help you and reall
Dear Surya,
I welcome your valuable feedback. The group is really doing well.
Dear members,
I agree with Surya's advice. We are here to help you and really expect
questions in easy understandable format. Please adhere group
guidelines too.
My sincere thanks to Top posters Shyam, Paul S, Paul W,
Hi All,
To my observations from the past, we have been 99 % sucessfull in answering
all the replies, but with some delays as some of us asking for a attachment
& few of us asking to clarify the question again, my understanding of
correct procedure to help in one single short way would be below.
either try my suggested code (which may solve both problems)
or try making sure the proper sheet is selected by using:
sheets("sheet1").Select
(insert appropriate sheet name)
Paul
From: Jonathan Posner
To: excel-macros@googlegroups.com
Sent: Fri, April 16, 20
Thank, Paul
Thanks so much for your suggestions on my second question!!!
Regarding my first questions:
Yes, the Select.Insert line and the CopyOrigin line are 1.
The error I get highlights columns and the error reads
"Compile error: Wrong number of argument or invalid property assignment"
The co
Please help
-- Forwarded message --
From: Rajesh Nair
Date: Fri, Apr 16, 2010 at 4:16 AM
Subject: $$Excel-Macros$$ Data requeired please help me
To: excel-macros@googlegroups.com
Hi All,
Please help me to pull data from sheet 1 to sheet2 in a column by clicking
a command butto
Hi All,
Check this excel.
Regards,
Swapnil.
On Fri, Apr 16, 2010 at 1:51 PM, MD18358 wrote:
>
> GAURAV and everyone.
>
> Thank you so much for the collective energy to resolve my questions.
> It seems like it was a great brain teaser.
>
> Here is my confession. I realize "now" that this has
1. I assume the Selection.Insert line and the CopyOrigin line is really
one line and googlegroups wrapped it.
If so, then your code worked fine for me.
which line is giving you the error?
2.
You can try this:
If (Range("C1").Value = "Onset") Then
Range("C1").EntireColumn.Select
ElseIf (Range("C1
You could:
add a column, use
=round(sourcecol,0)
copy down the list
then copy the column and paste special "values"
back to the first column.
or... you could check your source data and round at the calculation the next
time the file is generated.
hth
Paul
F
OK I modelled this to work with QX (see 'ForLouisZA.xls' in the files
section), however, can't you just take the total per time interval and
divide by the number of days in the total database? In the model, I've
shown both ways of doing it. The model has 30 min intervals from 6am
to 8pm, 16-20 Apri
Hi all,
I have a large spreadsheet file that has a lot of links and totals in
it. Unfortuantly the totals have a lot of rounding errors. I can fix
this by going into every cell and typing =Round(***,0). The only
thing is that this would take me for ever. Is there a way to
highlight a larg
Hi Friends,
Thanks, Thanks, Thanks, Thanks, Thanks, Thankyou very much
one more request How to remove the page breaks both in portrait and
landscape
On Fri, Apr 16, 2010 at 12:59 PM, Kumar wrote:
> Hi Sundarvelan,
>
> See if the below code helpful for your task:
>
> '
Hi,
If you have both date and time in each cell, then it is a simple subtraction,
with the right formatting in the results cell.
If you only have times, without dates, then XL would have to guess how many
days existed between the two times.
Regards - Dave.
> Date: Fri, 16 Apr 2010 00:09:13 -070
GAURAV and everyone.
Thank you so much for the collective energy to resolve my questions.
It seems like it was a great brain teaser.
Here is my confession. I realize "now" that this has tremendous
practical use in business and school. However, I needed this
assistance for a much "higher callin
Hi Sundarvelan,
See if the below code helpful for your task:
'===
ActiveSheet.PageSetup.RightHeader = ""
ActiveSheet.PageSetup.CenterHeader = ""
If WeekdayName(Weekday(Date)) = "Monday" Then
ActiveSheet.PageSetup.LeftHeader = FormatDateTime(
Hello,
I need to subtract a specific time in one cell from another time
another cell to produce the difference of the two times. I also need
to consider passing through midnight, i may have a time on one day and
have to subtract it from a time on the next day.
Thanks in advance,
Steve
--
--
Hi,
If I understand you correctly, the following line of code does what you ask, to
the active cell.
If Weekday(Date) = 2 Then ActiveCell = Date - 3 Else: ActiveCell = Date - 1
Regards - Dave.
Date: Fri, 16 Apr 2010 10:36:13 +0530
Subject: $$Excel-Macros$$ Excel-Macros : Help
Fro
31 matches
Mail list logo
