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)
& "=" & """
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 wrote:
> HI,
> If you want to put formula by vba please try this
>
> Sub fillformula()
> Dim lngLastRow As Long
> Dim lngLastCol As
OK, I got it, Thank you very much Mr.Ravinderji.
On Wed, Mar 19, 2014 at 2:33 PM, Ravinder wrote:
> 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
> *Sent:* Wednesday, Marc
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 wrote:
> great...thanks priti..
>
>
> but the range you mentioned I3:I54... it could be vary.. its not dynamic.
>
>
> Thanks & Regards,
> Pra
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 official
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 wrote:
> Dear team i am using multiple excel sheets. However i am facing a common
> problem with all files that when i press ctrl+s onl
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
7
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
wrote:
> 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-Mac
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 = Sheet2.UsedRange.
There is some update as last output is not correct
On Thu, Mar 20, 2014 at 8:38 AM, AK 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:
>> excel-macr
13 matches
Mail list logo