Hi
PFA
Cheers!!
On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema
wrote:
> Hai friends
>
> I am attaching an Excel workbook for an apartment maintenance.
>
> sheet1 i considered as Main page,
>
> sheet2, sheet3 will hold individual accounts and their balances
>
> when the extract ba
Hai friends
I am attaching an Excel workbook for an apartment maintenance.
sheet1 i considered as Main page,
sheet2, sheet3 will hold individual accounts and their balances
when the extract balances button pressed on the sheet1 page, the names of
the remaining worksheets should come
presumably you want all the totals on the same line, so really just need to
find the bottom of the first column, k
The array is the column# you want totals for.
endrow=cells(65536,3).end(xlup).row
for each col in array(11,15,16,20,21)
cells(endrow+1,col).value=worksheetfunction.sum(columns(col)
thank you
On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi wrote:
> check this file.. press Alt + F8 to run macro
>
> Cheers!!
>
>
> On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote:
>
>> is any solution from expert?
>>
>>
>> On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
>>
>>> just copy p
do you want data to populated in table? how? VBA / Formula?
On Wed, Aug 6, 2014 at 8:57 PM, KATHIRVELAN N
wrote:
> Dear Friends,
>
> Could you please help me in getting the report like below.
>
>MODALITY TIME STAMP USED MINUTES NOT USED MINUTES CT 7-9 9-11
> 11-13 13-15 15-1
Check this for how you can work on color set by conditional formatting in
XL2007..
http://www.xldynamic.com/source/xld.CFConditions.html#specific
Cheers!!
On Thu, Aug 7, 2014 at 6:56 AM, Daniel Parmet
wrote:
> I have a macro (first I've ever written!) that works wonderfully with
> cells that
check this file.. press Alt + F8 to run macro
Cheers!!
On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote:
> is any solution from expert?
>
>
> On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
>
>> just copy paste data to excel
>>
>> if i select A column data hit on button A column data conve
Hi Danj,
PF below is code.
i = Sheet1.Cells(Sheet1.Rows.Count, "K").End(xlUp).Row
Sheet1.Range("K" & i + 1).Value = WorksheetFunction.Sum(Sheet1.Range("K1:K"
& i + 1))
change columns in K for
*O, P, T, U, and V...*
Regards
Pramod
On Thu, Aug 7, 2014 at 8:50 AM, 'DanJ' via MS EXCEL A
Hello everyone,
I am trying to get the total of each column K, O, P, T, U, and V using the
codes below.
EndRowK = Sheets(1).range("K65536").End(xlUp).Row
Sheets(1).range("K" & EndRowK + 1).Formula = "=SUM(K2:K" & EndRowK & ")"
EndRowO = Sheets(1).range("O65536").End(xlUp).Ro
Dan, you can get it yo work in Excel 2010 or above. There is a property
they introduced which will help to identity the actual interior color or
the color rendered by conditional format.
Regards
Sam
On 7 Aug 2014 06:57, "Daniel Parmet" wrote:
> I have a macro (first I've ever written!) that work
Anil nim did you find any class or person?
I have already gone through the book excel vba programming for dummies
which is similar to the free vba course that was posted. I still need
further training so I was curious what you are doing.
On Tuesday, July 29, 2014 10:50:26 PM UTC-5, anil nim wr
I have a macro (first I've ever written!) that works wonderfully with cells
that have not been conditionally formatted:
I need help with:
Function CheckColor(range)
'Returns Opportunity Words on deal score value.
If range.Interior.Color = RGB(198, 239, 206) Then
CheckColor = "Oppor
*Please respond to gurjant.si...@damcosoft.com
Position: Sales Force Developer Location:
Chicago, ILDuration: 6+ Months*
*Need Visa copy at the time of submission.*
JD:
Key Technical SkillSalesforce; Apex; VF
Experience Level 7-8 years
Project Summary
Responsibility
*Please respond to gurjant.si...@damcosoft.com
*
*Position: Developer (.Net/ Java)Location: Chicago, ILDuration: 6+ Months*
*Need Visa Copy at the time of submission.*
JD:
Key Technical SkillSalesforce; Apex; VF
Experience Level 7-8 years
Project Summary
Responsibili
You can simply use a formula like:
=IF(A2<>"",SUBSTITUTE(TEXT(A2,"0-000-000-000"),"919-","9-"),"")
and copy down/across.
Why do you want a macro?
Do you know how to write macros?
If not, then you're asking one of us to write it for you,
you'll have to provide much more information.
How many ro
is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
> just copy paste data to excel
>
> if i select A column data hit on button A column data convert in to 10
> digit no...
>
> i want data as text also convert in to number & it must be 10 digit mobile
> no
>
>
Dear Team
You have ebook Excel VBA Programming FOR Dummies 1st EDITION 2010,
Please send soft copy
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
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 @
ht
17 matches
Mail list logo
