Dear Experts,
I want to create a Google spreadsheet , which will be shared with pan India
Team,
I will have a summary or dashboard file located on my PC hard drive. now i
want when a team member updates on spreadsheet it should reflect on my
Summary or Dashboard file automatically. it should same
HI,
If you want to put formula by vba please try this
Sub fillformula()
Dim lngLastRow As Long
Dim lngLastCol As Long
lngLastRow = Sheet2.UsedRange.Rows.Count
lngLastCol = Sheet2.UsedRange.Columns.Count
Sheet2.Range(d3).Formula = =iferror(if( Range(c3).Address(0, 1)
= Count
great...thanks priti..
but the range you mentioned I3:I54... it could be vary.. its not dynamic.
Thanks Regards,
Prabhu R
On 19 March 2014 13:08, priti verma pritiverma1...@gmail.com wrote:
HI,
If you want to put formula by vba please try this
Sub fillformula()
Dim lngLastRow As Long
OK, I got it, Thank you very much Mr.Ravinderji.
On Wed, Mar 19, 2014 at 2:33 PM, Ravinder ravindervbacli...@gmail.comwrote:
Pfa… put correct formula for B4 and B5 in vba code….
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara
moreover priti..
its working if C3 is Countsame way i need to calculate for Error.
Thanks Regards,
Prabhu R
On 19 March 2014 14:35, Prabhu Pinky prabhupin...@gmail.com wrote:
great...thanks priti..
but the range you mentioned I3:I54... it could be vary.. its not dynamic.
Thanks
Dear team i am using multiple excel sheets. However i am facing a common
problem with all files that when i press ctrl+s only then formulas are
showing value. Otherwise they are zero.
--
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
You probably have the calculation in Excel set to Manual. In Excel
Options, change it to Automatic
HTH/Abhishek
On Wed, Mar 19, 2014 at 4:55 PM, Kush Shama kushleshsha...@gmail.comwrote:
Dear team i am using multiple excel sheets. However i am facing a common
problem with all files that when
Hi All,
I need to count the non-blank cell from the latest month (Cell M1 -- Feb
2014) to last blank cell and ignoring rest of the previous values.
countblank or CountA formula is not working as they are counting all the
cells in the range.
For example 1: If I need to update cell N2 the value
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of AK
Sent: Wednesday, March 19, 2014 8:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Count help
Hi All,
I need to count the non-blank cell from the latest month (Cell M1 -- Feb
I need your help.
let us suppose I have an excel sheet as below
*Original data*
month
X
Y
Z
Jan-13
1
2
3
Feb-13
4
5
6
Mar-13
7
8
9
Aug-13
1
2
3
*After Imputation*
month
X
Y
Z
Jan-13
1
2
3
Feb-13
4
5
6
Mar-13
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
ravindervbacli...@gmail.comwrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *AK
*Sent:* Wednesday, March 19, 2014 8:15 AM
*To:* excel-macros@googlegroups.com
try this
Sub fillformula()
Dim lngLastRow As Long
Dim lngLastCol As Long
Dim wksAudit As Worksheet
Dim rnglookup As Range
Dim rngCriteria
Dim rngCell As Range
Set wksAudit = ThisWorkbook.Worksheets(Audit details)
Set rnglookup = wksAudit.UsedRange
Set rngCriteria =
There is some update as last output is not correct
On Thu, Mar 20, 2014 at 8:38 AM, AK exce...@gmail.com wrote:
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
ravindervbacli...@gmail.com wrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
13 matches
Mail list logo