Hi Experts
I have created a list in "Name Manager" named "TTlist" for values shown in
"LIST" sheet of attached file. I used to update this "TTlist" with some
other macro.
I have another sheet named "TT" in which 1st 5 rows are constant. I sued to
fill-in data from 6th row on-wards.
I need a macro
Thank you sir! it worked amazing
--- On Wed, 11/28/12, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ Small Date Query
To: excel-macros@googlegroups.com
Date: Wednesday, November 28, 2012, 12:30 AM
check the attachment see if it helps
On Tue, Nov 27, 2012 at 11:14 PM, K
Hi,
If year,month,days are in A1,A2,A3 respectively then put the date on which
you want to calculate in A4,
enter the formula in A5(the joining date,if it is one complete spell,
=Date(Year(A4)-(A1),Month(A4)-(A2),Days(A4)-(A3))
R.Karunanithi
From: MRafiqu
maybe someone else can post a code for that, it doesn't take long. Start
from mine, improve it...
--
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 Help,
Hi Ganesh
I have currently too little time until end of week to look at your query.
Just check that everything is on C: path drive and that a folder merge
exist on the same location.
Else, I'll have to look closer.
Regards
Pascal
--
Join official Facebook page of this forum @
https://www.fa
I do not understand your problem.
You SAID:
"I have table that give me sequence as I want..
Everything is fine till I bring numbr forward, like 10.
When I push something backwords is not working, like 9."
What do you mean "bring number forward" and
"push something backwards".
I was able to
check the attachment see if it helps
On Tue, Nov 27, 2012 at 11:14 PM, Kenil Gala wrote:
> Pls help me solve my query.
>
> I have mentioned my query in the file attached.
>
> Thanks & Regards,
> Kenil Gala
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexc
Here's what I came up with:
Weekly
From =$A5+1-WEEKDAY($A5,2)
TO =$A5+7-WEEKDAY($A5,2)
Monthly
From =DATEVALUE(MONTH($A5)&"-1-"&YEAR($A5))
TO =EOMONTH($A5,0)
Quatrly
From =DATEVALUE(ROUNDUP(MONTH($A5)/3,0)+2*(ROUNDUP(MONTH($A5)/3,0)-1)&"-1-"&YEAR($A5))
TO =EOMONTH(I5,2)
Half Yearly
Pls help me solve my query.
I have mentioned my query in the file attached.
Thanks & Regards,
Kenil Gala
--
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, N
Sub emailstest()
' run loop here
Dim bdy As String
Dim bdyrng As Range
Dim cl As Range
Set bdyrng = Sheets(1).Range("g2:g50")
For Each cl In bdyrng
bdy = bdy & vbNewLine & cl.Text
Next
' run loop here
Call send_emails(Range("b2").Text, Range("c2").Text, bdy)
End Sub
Sub send_emails(to1
Hi Ashish,
Please find attached text files and excel sheet for your reference.
Please let me know if you have any clarifications.
Regards,
Ganesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thr
share some sample text files
On Tue, Nov 27, 2012 at 8:21 PM, Ganesh wrote:
> Hi Pascal,
>
> I am not get correct solution from this coding
>
> Please help !!!
>
>
> On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
>
>> Another shorter programming solution would have been to autofilter c
Hi Pascal,
I am not get correct solution from this coding
Please help !!!
On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
> Another shorter programming solution would have been to autofilter column
> B and copy visible cells into a table and do the same thing and
> let CopyDataToTxtFil
can u share the sample workbook
On Tue, Nov 27, 2012 at 8:01 PM, Rajan_Verma wrote:
> *You can go here and can modify the code as per your need *
>
> * *
>
> *http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/*
>
> * *
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
>
if you rows and columns are fixed why do u create a blank template in word
document , merge cells , row ,etc as per your need
Then run a loop through all the cells in table to add data in word document
Regards
Ashish
On Tue, Nov 27, 2012 at 6:15 PM, Jewel Sharma wrote:
> Guys - I'm facing is
You can go here and can modify the code as per your need
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mel
Sent: 27 N
Sub emailstest()
' run loop here
Call send_emails(Range("a2").Text, Range("b2").Text, Range("c2").Text)
End Sub
Sub send_emails(nm As String, to1 As String, cc1 As String)
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim fld As Object, fil As Object
Dim attach1 As String
Se
-- Forwarded message --
From: ysofia
Date: Tue, Nov 27, 2012 at 2:41 PM
Subject: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon
Location
To: daksh1...@gmail.com
*Dear Candidate,*
This is *Sofia* from *Magna InfoTech*.
We have an urgent requirement for* VBA, Macros
1.
I have a number of spreadsheets in one folder. For each spreadsheet, I
need to open, then copy all 6 tabs (all have the same name: Option A,
Option B, Option C, Francais A, Francais B, Francais C) to a new sheet and
name the new sheet with the the same name as the ori
Guys - I'm facing issues with "column width" when pasting from Excel to
Word.
Briefly,
- I have an Excel file comprising of several worksheets. Each worksheet
comprises of several tables (with specific column width and row heights).
- Certain cells within these tables are merged while o
Hey welcome
Keep Posting!!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Jorge Marques
Sender: excel-macros@googlegroups.com
Date: Tue, 27 Nov 2012 12:25:10
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi all Exc
Hi all Excelers,
Jorge Marques from Portugal, work in a Logistic Company and Excel is now
part of my life, my learning curve in VBA is improving alot since I
discovered this group, also use chandoo.org because it has some awesome
stuff, regarding formulas and Charts. In my spare time I´m learning S
Welcome n Keep posting!!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kuldeep Singh
Sender: excel-macros@googlegroups.com
Date: Tue, 27 Nov 2012 17:26:16
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi Bhanu & Amo
Amol Shrivastava From Mumbai...thanks
On Tue, Nov 27, 2012 at 5:22 PM, bhanu prakash wrote:
> Dear All..
>
> Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part
> of loverly group...Keep rocking..
>
> Thanks
> Bhanu
>
>
>
> On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain wrote
Dear All..
Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part
of loverly group...Keep rocking..
Thanks
Bhanu
On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain wrote:
> CSk, start the new topic please
>
> Thanks.
> On Nov 25, 2012 10:01 PM, "CSK" wrote:
>
>>
>> hi sir
>>
hi Kenil Gala,
find the attached file it will solve your prob
regards
Delin.F
From: Kenil Gala
To: excel macros
Sent: Monday, 26 November 2012 8:48 PM
Subject: $$Excel-Macros$$ Small Query
Hi,
Pls help me solve my small doubt.
I have written i
26 matches
Mail list logo
