Hi,
Would it be possible for you to attach a sample sheet?
Regards,
Andy
On Sat, Jun 26, 2010 at 4:34 AM, Nadine S wrote:
> I have two worksheets:
> Sheet 1 contains extracted data from an application
> Sheet 2 is my working file
>
> I need to match 3 different columns in sheet 2 to those colu
I have two worksheets:
Sheet 1 contains extracted data from an application
Sheet 2 is my working file
I need to match 3 different columns in sheet 2 to those columns containing the
same data in Sheet 1 and I need the formula to return the corresponding value
in another column in sheet 1. Thi
I have the Excel VBA 2007 book by Mr Excel. It is a good book to get
you up and running and it is good to reference back to. I still find
using online resources and videos helpful as well. on the Mr Excel
site you will find over 600 video podcasts(though video quality a
little lacking) and a forum.
Hi SACHIN,
I think this will work, although it is not able to figure out
"breaks". It simply finds the smallest time and the largest time and
finds the differance.
Sub FigureTime()
' FigureTime Macro
' 6/25/2010 by David Lanman
Range("G2").Select
Do Until ActiveCell.Offset(1, -1).Value =
David
Thanks for the reply. I am now thinking that it is not possible. I
have though of a few possible variations that might work, but they are
not ideal and will need testing.
Bob
On Jun 23, 8:22 pm, who wrote:
> Hi Bob,
>
> I think it will be difficult to stop Solver, once it starts its
> ite
First of all, you're disabling the events, then never re-enabling them if the
value is not "yes".
I would first test to see if the changed cell is in the target range,
then test the value, THEN disable the events, make the changes,
then re-enable the events.
If you change a cell NOT in column
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your requi
This is one of the things I enjoy about participating in this group!
Nearly a year ago, someone asked about something similar.
(It may have been in a different group, I'm in several)
Well.. I had something CLOSE, but it wasn't dynamic.
That is, it couldn't "grow".
And... they were asking for it to
Hi Anton,Glad it works well for you.To keep the cursor in the same cell, add
the following line to your code:Target.Select
So the macro will now look like this:
Private Sub Worksheet_Change(ByVal Target As Range)If Target.Column = 2 Then
Target.Offset(0, 1) = Target.Offset(0, 1) + TargetTarget.S
So I have a file where a task/person responsible etc. is listed
When the task is completed, I would like to enter yes and upon this
text entry, the file would delete that line and add it to another tab
with other completed tasks. I need other entries of text to have
nothing done.
Task Person Com
Hi friends
I have made a chat site using php and mysql.
it is http://mylogo.0fees.net .
Is there a way to automatically back up the database to an excel workbook
using VBA macros?
I mean is there a way to make a POST data request without user interface?
Any help is verymuch appreciated :)
Hem
Paul, this is GENIUS! You have saved me. This is absolutely 100% exactly
what I need - and it works perfectly.
Thank you SO MUCH!
Leigh
On Fri, Jun 25, 2010 at 8:12 AM, Paul Schreiner wrote:
> I did not test it EXTENSIVELY, especially the width of the panel.
>
> but it should give you someth
You are welcome Mathan...!! :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 6:44 PM, Mathan wrote:
> Thanks a lotSimply great!!!
>
>
> On Fri, Jun 25, 2010 at
What type of solution are you looking for?
VBA? or Excel functions?
If you're wanting a brute-force method, I would:
Insert a column and use it to combine the userid and date (=A2 & ":" & B2)
copy it down, then copy, paste sepecial-> values to remove the formulas.
Copy this column to a new sheet.
Thanks a lotSimply great!!!
On Fri, Jun 25, 2010 at 6:12 PM, Dilip Pandey wrote:
> Hey Aindril thanks for your encouraging words... :)
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New
Hey Aindril thanks for your encouraging words... :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 5:38 PM, Aindril De wrote:
> Hi Dilip,
>
> This is an excelle
I'll throw something together and send it this morning.
Paul
From: Donna Feauto
To: excel-macros@googlegroups.com
Sent: Thu, June 24, 2010 3:01:22 PM
Subject: Re: $$Excel-Macros$$ Select files via checkboxes, then copy those
files to a new directory
Thank yo
Hi Dilip,
This is an excellent solution you have provided.. Hats off to you for
keeping it so simple..
Cheers,
Andy
On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey wrote:
> Hi Mathan,
>
> Attached file has been solved per your requirements. Please let me know if
> it solves your problem else ge
Dear Taruna,
Try subscribing various online Google / Microsoft forums as well, which will
benefit you in your learning.
Start with Recording macro and then look out the codes in the visual basic
editor.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilip
you can use "powerpnt" to open the MS Powerpoint with help of run
command.
Regards,
Rahul Gandhi
+91-9711772297
On Jun 25, 9:00 am, "Rohit Garg" wrote:
> Powerpnt
> Regards,
>
> Rohit Garg-Original Message-
> From: janet dickson
> Sent: 24/06/2010, 9:51 PM
> To: excel-macros@googlegr
Use This formula just change the range
=SUMPRODUCT(MAX(($A$2:$A$100=A3)*($D$2:$D$100)))
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
Dear Ashish,
For that you download a pdf995 from http://www.pdf995.com/ as pdf printer &
when u print the document please select pdf printer then your file is
convert into pdf.
vikas goel
On Tue, Jun 22, 2010 at 10:55 AM, Ashish Khandelwal
<4everash...@gmail.com>wrote:
> Hi,
>
> How to convert
Right...!!
And ideally it would work for all the registered programs in windows. Check
the attached image which has the name of the program (.exe) and it is the
name which should be entered in Start->Run command.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 98109
Hi Mat,
Would it be possible for you to share that spreadsheet where you have copied
cross tab query.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 12:08 PM, Mat w
Hi Anil,
Are you looking out to create pivot table in MS Word OR you want to create
pivot table in MS Excel using data source from MS Word ?
I think below link might help you:-
http://support.microsoft.com/kb/170745/en-us
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile:
Hi all,
I copied an access cross tab query into a worksheet and when I high
lighted a couple of rows the inbuilt count function was counting the
empty rows!?! (!?! for effect :)
I used count(cell) and len(cell) and code(cell) and nothing is there.
count(cell) returned 0.
It is clear that the cro
Hi Dave
Yes, I want Exacyly as u said. That is I want formula + formating ( ie BOLD
& Italic)
If any one knows pls resolve this
Thanks & Regards
Dharmesh Shah
On Thu, Jun 24, 2010 at 10:09 AM, Dave Bonallack
wrote:
> No, I think he wants the formatting present in Cell A3, but I don't think
27 matches
Mail list logo
