*Please respond to gurjant.si...@damcosoft.com
*
*Position: Perl DeveloperLocation: Remote, anywhere in USADuration: 6
months, possibility of extension*
Requirements/Skills:
•Total Experience: 6-8+ years
•Perl/shell programming
•System level skill
•Good old OO programming
Than
Thank you very much, Paul. When I received the file, it was quickly
obvious that this other party had introduced an error into the file that
was producing a bunch of #0's and such and that the goal seek would never
be able to find a solution. I guess these VBA error messages are just too
gene
Hey Paul.
I want to append all word documents to the first word document (which is
always a "Cover" for the report).
best,
On Monday, July 21, 2014 2:28:47 PM UTC-3, Paul Schreiner wrote:
>
> Are you saying you want to copy the CONTENT of the Word Documents to an
> Excel workbook? or append ea
Are you saying you want to copy the CONTENT of the Word Documents to an Excel
workbook? or append each of the Word Documents to a new Word document?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you c
I'm creating an internal report for a company, which can be composed of up
to 8 separate sections (8 independent documents). Depending on the client,
I want it to use sections X, Y, Z, etc. Each section is already in a
separate word document (a basic template).
I have managed to correctly crea
Hi Vaibhav Ji,
This sheet is Working better than the first one.
Tremendous..!!!
Regards
Ashish
On 21 July 2014 20:03, Vaibhav Joshi wrote:
> Hi
>
> Check this, i have added Ok button in First form, only after pressing Ok
> now form 2 will appear & also added check box in front of cc but
Dear Vaibhav Sir,
Working Fine.
Thanks
Ashu Kenith
On 7/21/14, Vaibhav Joshi wrote:
> Hi
>
> Check this, i have added Ok button in First form, only after pressing Ok
> now form 2 will appear & also added check box in front of cc button to keep
> & remove cc.
>
> Thanks
>
>
> On Mon, Jul 21, 201
Oops, yes you included the range in the indirect() string.
so, the solution was simply using the text() function to convert the date
number to a string
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places
By way of explanation:
The Dates you have in column "A" are actually numbers.
(the number of days since 1/1/1900)
The sheet names are strings (of course)
So, from looking at your sheet names, 7/1/2014 is actually:
7-Jan-2014, which, to Excel is: 41646
To convert this number to a string that
For your sumif(Indirect function in cell B5, try:
=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
(It should copy to D, F, H, J also)
Paul
-
“Do all the good you can,
By all the means you can,
Hi Vaibhav,
Thanks a lot for your reply. I found that what mistake I am doing.
Is there any way that we can give the reference of the date field in the
summary sheet science I have all the sheet with dates only.
That can much faster for me to finish out.
On Mon, Jul 21, 2014 at 5:45 PM, Vaibh
what you are trying to achieve?
On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar wrote:
> Dear Friends,
>
> Please find attached Daily Reporting Formate of Excel in the summary sheet
> I am unable to get the vales using indirect function.
>
> Please help me friends.
>
> --
> Regards,
> Dileep Kuma
Did you tried macro?
It is giving same data which you highlighted in Yellow in result sheet!!
what extra you want?
Cheers!!
On Mon, Jul 21, 2014 at 4:57 PM, City Motors
wrote:
> Sir,
> not only to our boss, all confernce log
> ex: our customer called me(my landline no) i hold that call and co
Sir,
not only to our boss, all confernce log
ex: our customer called me(my landline no) i hold that call and connect to
you via conference call and you spoke me and my customer.
means any conference log entry sir,
thanks for replying soon,
From:
Vikas
On 21 July 2014 13:40, Vaibhav Joshi wro
First of all, if you saved it as a "macro enabled workbook file",
that means you saved it as a .xlsm file.
If so, they could NOT have opened the file with a version of Excel prior to
2010.
So, that just leaves a "newer" version, which I wouldn't jump to immediately.
Which line is showing the err
Ok,
can you explain one example too for better inderstanding...
Cheers!!
On Mon, Jul 21, 2014 at 2:02 PM, VETRI S P wrote:
>
>
> On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>>
>> can you attach sample sheet to make work simpler..
>>
>> Cheers!!
>>
>
> Sir,
>
> Sample File att
Sir,
Sample file is here
Regards
On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>
> can you attach sample sheet to make work simpler..
>
> Cheers!!
>
>
> On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P > wrote:
>
>>
>>
>> Sir,
>>
>>
>> I have two Excel sheets in which one is Master Da
On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
>
> can you attach sample sheet to make work simpler..
>
> Cheers!!
>
Sir,
Sample File attached
Pl find a way to compare and copying data within sheets
>
> On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P > wrote:
>
>>
>>
>> Sir,
>
Check this:
http://stackoverflow.com/questions/11263483/how-do-i-trigger-a-macro-to-run-after-a-new-mail-is-received-in-outlook
Cheers!!
On Mon, Jul 21, 2014 at 1:41 PM, Vaibhav Joshi wrote:
> Hi
>
> Macro which you gave is not related to what you wanna do!!
>
> what exactly you wanna do when
Hi
Macro which you gave is not related to what you wanna do!!
what exactly you wanna do when outlook receives email etc...
Cheers!!
On Mon, Jul 21, 2014 at 10:00 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA
MACROS wrote:
> Dear expert,
>
> I have a macro
>
> Private Sub Workbook_BeforeSave(ByV
Hey
check this sheet, click blue button to run macro..
When prompted enter what identifies your boss, by default i have taken your
example given so just enter to continue..
On copying data you will get Msg done..
Awaiting your feedback..
Cheers!!
On Mon, Jul 21, 2014 at 12:54 PM, wrote:
>
Cheers Ashish Kumar ji!!
On Mon, Jul 21, 2014 at 10:21 AM, Ashish Kumar
wrote:
> Hi Vaibhav,
>
> Its Great buddy.
>
>
> Regards
> Ashish
>
>
> On 19 July 2014 22:02, Vaibhav Joshi wrote:
>
>> Check this..
>>
>> Cheers!!
>>
>>
>> On Sat, Jul 19, 2014 at 2:32 PM, Vijay wrote:
>>
>>> Dear Team,
Hi
PFA, click on blue button to Run Macro, after that enter values & there you
go...
Cheers!!
On Mon, Jul 21, 2014 at 12:45 PM, Adrian Ion Tudor <
ion.adrian.tu...@gmail.com> wrote:
> Thanks for the quick reply,
>
> Attached a sample sheet
>
>
>
> *From:* excel-macros@googlegroups.com [mailto
Sir,
i am working in city motors agency
i enter all calls log which i made & received in excel sheet also in
register.
some time customer want to talk with our senior manager( boss)
than we connect to ur senior manager ( it is conference call) i highlighted
with yellow color.
now my request is
hey
Yes we can do wat you want, can you share sample sheet..
Cheers!!
On Mon, Jul 21, 2014 at 12:25 PM, Hendi Cluj
wrote:
> Basically i need a macro that does the following:
>
> i have a sheet in excel with items ( about 2815 items) each item has a 6
> digit code.
> The sheet looks like this
25 matches
Mail list logo
