Hi Ashish,
I have attached the sample sheets.
assume Master sheet is saved in D folder. and Consolidated sheet is saved
in E folder
Thanks Regards,
Prabhu R
On 24 November 2013 13:07, ashish koul koul.ash...@gmail.com wrote:
share some sample workbooks
On Sun, Nov 24, 2013 at 1:06 PM,
try this
=IF((ISERROR(VLOOKUP(B2,'C:\Users\admin\Downloads\[Master
Sheet.xlsx]Sheet1'!$B:$B,1,0))),Not Available,Available)
and apply conditional formatting in col a
or
Sub sample()
Dim wkb As Workbook
Dim i As Long
Set wkb = Workbooks.Open(C:\Users\admin\Downloads\Master Sheet.xlsx)
For i = 2
THANKS BRO REALY HEPLFULL ...
On Thursday, May 10, 2012 4:49:25 PM UTC+5:30, NOORAIN ANSARI wrote:
Dear Group,
Please find attached Interview questions and answers for MS Excel+VBA+MS
Access+SQL Server.
If any one have this type of question and answers, Kindly share with group.
Hello Ashish,
still its showing total for visible cell also that is 6 in this case. Is
there any function relate to pivot table?
Thanks in advance.
Regards,
Chandru
On Fri, Nov 22, 2013 at 7:39 PM, ashish koul koul.ash...@gmail.com wrote:
=SUBTOTAL(3,F:F)
On Thu, Nov 21, 2013 at 12:49
Dear All ,
Very Good Afternoon,
Please find the attachment where i have put value formula for date column
..but it is not working ..Same formula is working with other computer .
Please help for the same as i have same problem is since long .
Is there any setting i have to change in excel