Thanks in advance for your reply.
-Greg
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
orkbook is not named Combined, and it contains no data
from the other worksheets.
Thanks in advance for any assistance you can provide.
Kind regards,
Greg
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Ur
to copy the first row content one after the other into one large
worksheet.
Regards,
Greg
On Wednesday, June 6, 2012 6:59:27 PM UTC-4, Don Guillett wrote:
>
> I would have written it a bit more efficiently but what it is doing is
> copying all of current region of each sheet to a
Hi David,
Thanks for your reply. However, I tried this formula and it didn't work.
The result of the cell is 0. I wish to have the contents of each sheet
copied into one large worksheet.
-Greg
On Wednesday, June 6, 2012 6:49:01 PM UTC-4, David Grugeon wrote:
>
> You can use a f
Thank you Rajan,
This macro worked successfully. :-)
Is it possible to add a feature to the macro that will remove the header
row so that I don't have repetitive header information in the final
worksheet?
Regards,
Greg
On Thursday, June 7, 2012 9:11:07 AM UTC-4, Rajan_Verma wrote:
&
Wow that was fast! Yes, this is what I need. I will keep both version
because some times I need headers and other times sans headers. :-)
Thanks, I appreciate you creating this macro so quickly.
-Greg
On Thursday, June 7, 2012 10:44:53 AM UTC-4, Rajan_Verma wrote:
>
> Tr
Hi Don,
This macro works and accomplishes what I need. And I agree with your KISS
principle whenever possible.
BTW, if I want to use this same macro and keep the headers what must I
change?
Thanks,
Greg
On Thursday, June 7, 2012 12:52:25 PM UTC-4, Don Guillett wrote:
>
> I understo
://excelribbon.tips.net/T008884_Condensing_Multiple_Worksheets_Into_One.html
Thanks in advance for your help.
-Greg
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Thanks Ashish for your reply. When I use this macro I get the
following error message:
Compile error: User-define type not defined.
The following line in the macro code is highlighted:
Dim objShell As New Shell32.Shell
-Greg
On Jun 7, 2:22 am, ashish koul wrote:
> try this
>
automation in refrences
>
> tool -> reference -> Microsoft shell control and automation
>
>
>
>
>
>
>
>
>
> On Tue, Jun 7, 2011 at 7:11 PM, Greg wrote:
> > Thanks Ashish for your reply. When I use this macro I get the
> > following error me
Hi,
Can you help me write a macro that will type a custom function I created
into a cell? For example, I want the macro to type the following function:
=Switch2(Y2,"B", AH2,"H",NOT(AH2),"O")
inside cell AP2
Thanks in advance for your help.
Greg
--
Join offici
Thank you! This works and is just what I needed. :-)
Regards,
Greg
On Thursday, October 11, 2012 7:21:21 AM UTC-4, Prince wrote:
>
> Hi Gerg
>
> Just copy paste this macro and run it.
>
> sub test()
> with ActiveSheet
> .range("AP2").Formul
Hello -
I'm using an MS Query SQL statement to gather records from an Access
table. The table name varies depending on what I'm doing, so I'd like
to pass the table name and have it select records from that table.
Here is the command I have so far:
SELECT Owners.DisplayName, Owners.Owners
FROM `
;,
AH2,""H"",NOT(AH2),""O"")"
End With
How do I replace the AP1 and AP2 so that it uses a do loop?
Thanks in advance for your assistance.
-Greg
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
active when the workbook is recalculated. Does
anyone know how to fix this? I get the same error whether manually
recalculating with F9 or using Application.CalculateFull from VBA.
- Greg
Function GenCFD(InRange) As Variant
'randomly select values from an input of a cumulative freq
hem.
Thanks in advance for any assistance you can provide.
Kind regards,
Greg
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
eed to substitute the captured filename in
two places. Once containing the full path and filename and again with
just the filename.Thanks in advance for any assistance you can
provide.
Kind regards,
Greg
--
--
Some impo
managed to locate the following
FileDialog object that seem to provide what I want but I don't know
how to use them in a macro:
msoFileDialogFilePicker
msoFileDialogFolderPicker
Thanks in advance for your assistance.
-Greg
On Dec 9, 8:24 am, Paul Schreiner wrote:
> Check out the document
Hi Paul,
YES, this revised code is exactly what I needed!
Thanks, I appreciate your help.
Happy Holidays! :-)
-Greg
On Fri, Dec 17, 2010 at 2:40 PM, Paul Schreiner
wrote:
Sub GetFile()
Dim fso, File, fName, fPath, fDate
Dim msg
Dim MyFileName
Set fso = CreateObject
a.xls" available at the following weblink:
http://db.tt/Ynfa44I
Thanks in advance for your assistance.
-Greg
On Nov 12 2010, 3:38 pm, Greg wrote:
> Hi,
>
> I am a newbie to Excel and think I have a simple request but do not
> know how to get started. I would like to request help in
your additional
assistance. :-)
Regards,
Greg
On Jan 9, 9:52 am, ayush jain wrote:
> Hi Greg,
>
> Please see if the charts created in attached Excel workbook helps you.
> Feel free to write back if you need any further assistance.
>
> Thanks.
>
> Best Regards,
> Ayush Jain
maybe someone will need
http://training-course-material.com/training/Visual_Basic_for_Applications_(VBA)_in_Excel_-_Introduction_to_programming
--
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:/
should calculate to 45%. This would means the win percentage for
each player should be smaller as well.
Can you verify this?
Regards,
Greg
On Thu, Jan 20, 2011 at 12:03 PM, Ayush Jain wrote:
> Hi Greg,
>
> I have modified the Pie chart as required by you.
> Please see attached file and
Hi Ayush,
That's perfect! Exactly what I want.
Thanks,
Greg
On Thu, Jan 20, 2011 at 9:55 PM, Ayush Jain wrote:
> Hi Greg,
>
> See attached updated one.
> I hope it helps.
>
>
> Thanks.
>
> Best Regards,
> Ayush Jain
>
> On Thu, Jan 20, 2011 at 11
/18/2010, L Simms, L
10/18/2010, M Simms, L
10/18/2010, G Mouning, W
Regards,
Greg
On Fri, Nov 12, 2010 at 10:31 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> sample data pks
>
>
> On Sat, Nov 13, 2010 at 2:08 AM, Greg wrote:
>
>> Hi,
>&
Ashish - thank you for posting. I receive a #value! error in the distance
field. I am using Excel 2013, any assistance is greatly appreciated.
On Saturday, February 25, 2012 8:01:12 AM UTC-5, ashish wrote:
> Hi Group
>
> Try this udf it will help you in finding the time and distance between
.
Greg
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
l
End Function
OK, I said it was simple :) However, can anyone point to the problem in
this code. I have looked at it until I have become frustrated.
Thanks,
Greg
--
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 Facebo
Vicky, thanks for the idea. I will see how it works for me. I appreciate
the time/effort you put in to help me!
Greg
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
It’s okay to do
,
vbTextCompare) the function worked.
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
It’s okay to do what you did yesterday, but it will never be amazing again.".
- *Rod Favar
I have a sheet of responses to a short survey. The survey asked 4
questions with range answers (1 to 5, 5 being best), and then two
open-ended questions. I would like to count up the number of each
combination of answers with the range answers. So for all of the surveys,
I would like to
Paul, That is an excellent idea! All my survey results are on one page of
on workbook. So this should be fairly simple to write.
Thanks!!
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakth
OK, people, I like a good dialog as much as anyone else. But will you
please stop using this thread for your conversation!
Thanks,
Greg Della-Croce
--
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
This may not be the right place to post this question, however, you have
been great at helping me recently and I really appreciate it.
I have a data table in an Excel sheet. I imported 106 records into columns
A - G. I then highlighted them and created a table using the icon that
shows up at
to
how to accomplish this.*
*Any assistance would be appreciated. Thanks*
*Greg DC*
*Sorry I meant to say I am using Excel 2013 or a Win 7E Laptop. I am up to
date on all patches.*
--
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 o
OK, I know that this is a very simple error on my part. I put the Function
code in the Sheet2 General of the Project. I save the file, I save the
spreadsheet. I go to use it in a cell and it does not show up on the
function list. Yes I saved it as .xlsm, and Yes I enabled content. When I
g
Never mind found my error. Must be in a Module not Sheet2. My bad.
GregDC
On Friday, October 2, 2015 at 5:09:03 PM UTC-4, Greg Della-Croce wrote:
>
> OK, I know that this is a very simple error on my part. I put the
> Function code in the Sheet2 General of the Project. I save th
Since I do no see a way to do this with just functions, I think I am going
to have to write some code to do this myself, but I would appreciate a word
from the experts (aka you people)
I have a table with just shy of 50,000 rows that looks something like this:
Key1 Key2 MinDateMaxD
l the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Greg Della-Croce >
> *To:* MS EXCEL AND VBA MACROS >
> *Sent:* Sat
39 matches
Mail list logo
