Dear All,
I have multiple sheets say per location in a file
I wants to do a pivot from multiple sheet however I need to get the pivot next
to each other...
Is there any shortcut or macro?
Best Regards,
Amit
Disclaimer: This message and its attachments contain
ignore previous one.
pfa
On Sat, Jan 5, 2013 at 11:49 AM, The Viper wrote:
> pfa
>
>
> On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote:
>
>> Here is the anwser, I have attached a file with solution. Please reply if
>> you want this?
>>
>> --- On *Fri, 1/4/13, harshad shukla * wrote:
>>
>>
>
pfa
On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote:
> Here is the anwser, I have attached a file with solution. Please reply if
> you want this?
>
> --- On *Fri, 1/4/13, harshad shukla * wrote:
>
>
> From: harshad shukla
> Subject: $$Excel-Macros$$ Vlookup for two same values
> To: excel-m
Here is the anwser, I have attached a file with solution. Please reply if you
want this?
--- On Fri, 1/4/13, harshad shukla wrote:
From: harshad shukla
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Date: Friday, January 4, 2013, 2:47 PM
I was stuck up
apply the filter before protecting the sheet.
select the options "use filters" in sheet protection dialogue box
On Fri, Jan 4, 2013 at 3:17 PM, अनिल नारायण गवली wrote:
> Dear Dhaval,
>
> Hide the formula bar which is availabale in options tab of workbook.
>
>
> Thanks & Regards,
> Gawli Anil
>
>
Still finding the necessity for the lengthiest code from prince.
It can be achieved in few clicks through excel built in option called
"Remove Duplicates".
Assuming OP is using excel 2007 or later versions as he is working with 6
lakh records.
The below code is enough, even if we want to write in
Ayush,
Nowadays lots of spam in group. Moderators should be cautious
2013/1/4 سمية صفار
> اول موقع سكس شوب عربي
> يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة
> الاسعار المنافسة و الجودة العالية
> توفير كل طرق الدفع السهلة و المتاحة
> ضم الاف المنتجات الجنسية المتنوعة
> شحن الى الدول ال
Dear Gurus
I want to make a excel data entry form in which i want some cells to be
mandatory and some can be left out. But with sequence
Like
Name (Mandatory)
Address (Mandatory)
Phone ( not mandatory)
*first field entry should be name, he cannot move to phone directly until
name is filled. is
Hi All,
I want the font size to be 89mm, how do i do that?
Find the attached word document.
Thanks for your help.
*Regards*,
*Anupam Konhar*
*+65 - 9066 7141*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
Cerebral Palsy Alkanaa (worm)
click here
http://goo.gl/RMgJg
--
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, Formula Problem, Code Problem, and Ne
WOW! Suupe! Works like a magician wand.
Thanks thanks thanks a lot.
Regards
Rashid Khan
On Friday, January 4, 2013 8:38:18 AM UTC+4, Lalit Mohan Pandey wrote:
> Hi Rashid,
>
> Paste below code in the same module where the previous procedure is saved
> and assign this pro
اول موقع سكس شوب عربي
يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة
الاسعار المنافسة و الجودة العالية
توفير كل طرق الدفع السهلة و المتاحة
ضم الاف المنتجات الجنسية المتنوعة
شحن الى الدول العربية و تجاوز الجمارك
السرية و الامان
تنوع طرق الشحن و الاستلام
...
كما يتميز ال
Hi Jocky,
I have been given to simple way solution. Please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
> Hi Team,
>
> I have attached one excel sheet in wich i need to set the formula for the
> person for the entir
if on using VLOOKUP and for same item code and repeated twice in the
list,it should generate the corresponding inventory value .In actual only
the first value is taken repeatedly if the vlookup value is coming twice in
the list.
On Fri, Jan 4, 2013 at 5:00 PM, Prince wrote:
> explain bit more co
Hi Jocky,
Made changes in sheet removing validation to show up the values there. Find
attached the updated one.
On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma wrote:
> Hi Jocky,
>
> Formula's been written in validation rule which will restrict any entry
> other entry except 9:00:00 for Mon-Th
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except 9:00:00 for Mon-Thu and 12:00:00 for Sat - Sun.
Try to write something there, you'll get error prompting to enter valid
values.
On Fri, Jan 4, 2013 at 7:11 PM, ashwani agnihotri <
ashwani.agniho
please see if this helps...
On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta wrote:
> Hi Anoop,
>
> There is No formula in the attached sheet, :(
>
> On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote:
>
>> Hi Jocky,
>>
>> Please find attached with solution.
>>
>> Regards,
>> Anoop
>> Sr. Developer
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote:
> Hi Jocky,
>
> Please find attached with solution.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
>
>> Hi Team,
>>
>> I have attached one
You're great dude.
On Fri, Jan 4, 2013 at 5:31 PM, Prince wrote:
> most welcome dear.
>
> regards
> prince
>
>
> On Friday, January 4, 2013 5:08:01 PM UTC+5:30, amar takale wrote:
>
>>
>> Thank Very much...Prince
>>
>>
>> On Fri, Jan 4, 2013 at 4:37 PM, Prince wrote:
>>
>>> Public
same to u dear
On Friday, January 4, 2013 5:09:15 PM UTC+5:30, Jai Bhati wrote:
>
>
--
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, Formula Proble
most welcome dear.
regards
prince
On Friday, January 4, 2013 5:08:01 PM UTC+5:30, amar takale wrote:
>
>
> Thank Very much...Prince
>
> On Fri, Jan 4, 2013 at 4:37 PM, Prince >wrote:
>
>> Public Sub removeDuplicateId()
>>
>> Dim vardata As Variant
>> Dim varRes
Hi jocky Beta,
Please paste the this formula in Cell C6 With Ctrl+Shift+Enter
=IF(AND(($B$6=$A$13),SUM((C$4=$D$4:$H$4)*1)),$B$13,$B$14)
and C7
=IF(AND(($B$7=$A$15),SUM((C$4=$D$4:$H$4)*1)),$B$14,$B$13) with CSE
Regards
Prince
On Friday, January 4, 2013 4:59:03 PM UTC+5:30, jocky Beta wrote:
>
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
> Hi Team,
>
> I have attached one excel sheet in wich i need to set the formula for the
> person for the entire week.i.e is if one person is working form Mon to Fri
>
Thank Very much...Prince
On Fri, Jan 4, 2013 at 4:37 PM, Prince wrote:
> Public Sub removeDuplicateId()
>
> Dim vardata As Variant
> Dim varRes As Variant
> Dim lngRow As Long
> Dim objDic As Object
>
>
> Set objDic = CreateObject("Scripting.Dic
explain bit more could't understand ur requirment.
Regards
Prince
On Friday, January 4, 2013 4:52:35 PM UTC+5:30, harshad shukla wrote:
>
> Please find attachd file.if two values of material code is same then
> corresponding target inventory value should be displayed.ordinary only one
> value i
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
person for the entire week.i.e is if one person is working form Mon to Fri
it should mark 9:00 and when same person working on Sat & Sun it shoud mark
the time as 12:00
Please help me on this
--
Join official Fac
Hi Amar,
I have programmed below code just cut and paste this and run
Public Sub removeDuplicateId()
Dim vardata As Variant
Dim varRes As Variant
Dim lngRow As Long
Dim objDic As Object
Set objDic = CreateObject("Scripting.Dictionary")
Dear All,
I want VBA Code to remove Duplicate Email ID from 6 Lack Email ID
Amar
--
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, Formula Problem,
yes, Just Follow the below mentioned steps:
first select the cells thhat you want to lock and then right click on this
select format cells now choose protaction Tab and then select the hidden
and locked option on the popup window at last protact your sheet.
Regards
Prince
On Friday, January
Dear Dhaval,
Hide the formula bar which is availabale in options tab of workbook.
Thanks & Regards,
Gawli Anil
On Fri, Jan 4, 2013 at 2:46 PM, Dhaval Shah wrote:
> Dear friends
>
> i am lookking for solution 4 Lock work sheet if i am lock work sheet then
> i m not able to use filter .
Share your workbook.
Regards
Prince
On Friday, January 4, 2013 2:47:55 PM UTC+5:30, harshad shukla wrote:
>
> I was stuck up with a problem.i have to use vlookup .but in case of two
> same values i want distinct values as answer.i.e. if table has two common
> values .the vlookup should give va
I was stuck up with a problem.i have to use vlookup .but in case of two
same values i want distinct values as answer.i.e. if table has two common
values .the vlookup should give values as separately.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Dear friends
i am lookking for solution 4 Lock work sheet if i am lock work sheet then i
m not able to use filter
actually i want to hide my formula's only is it any way to hide formula ???
Thanks
Dhaval Shah
--
Join official Facebook page of this forum @
https://www.facebo
33 matches
Mail list logo