t; Kishore
>
> On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde
> wrote:
>
>> Dear All
>>
>> I have a work book which contain many daywise sheet in which I maintain
>> machinewise data.
>> I have 20 machines all machines are not running daily so if ma
Can Anyone please help me?
On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde
wrote:
> Dear All
>
> I have a work book which contain many daywise sheet in which I maintain
> machinewise data.
> I have 20 machines all machines are not running daily so if machine is not
> runnin
Dear All
I have a work book which contain many daywise sheet in which I maintain
machinewise data.
I have 20 machines all machines are not running daily so if machine is not
running I hide that rows and machine running will be visible.
There is down time for a machine having many reasons which are
" sec"
> MsgBox msg
> 'xxxxxxxx
> xxx
> End Sub
>
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the m
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
Dear Friends
Waiting for reply
-- Forwarded message --
From: Shrinivas Shevde
Date: Tue, Jan 3, 2017 at 4:55 PM
Subject: $$Excel-Macros$$ Macro for Copy Paste
To: excel-macros@googlegroups.com
Dear All
I want a macro for following can Anyone help me.
I have a folder ,which
Dear All
I want a macro for following can Anyone help me.
I have a folder ,which contain many folder,In each folder there are
excel file(File having single sheet) .I want to copy E3,F5,E8,E9 from
each file and paste in one excel sheet.
For eg
Suppose main folder name is "complete"
In this folder t
ng, Let me know if i am not able
> to answer your question.
>
> Regards
> Gaurav Devrani
> 8586932754
>
> On Tue, Aug 9, 2016 at 6:00 AM, Shrinivas Shevde
> wrote:
>
>> Dear Sir
>> Thanks for Problem
>> Actually I want to copy paste more than 50 items from v
attached file. Let me know if this does not solve your
> query.
>
> Regards
> Gaurav Devrani
>
> On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde
> wrote:
>
>> Dear all
>> I have data in Column A in 1to 6 rows . I want to copy paste in Column F
>> but in co
Dear all
I have data in Column A in 1to 6 rows . I want to copy paste in Column F
but in column F 2 rows are merged .I want outout as shown in column I but I
am getting as shown in F .Is there any way o copy paste data from non
merged cell to merged cell
Thanks in Advance.
--
Shrini
--
Are you
t;).Select
> Selection.AutoFilter
> ActiveWorkbook.Save
>
> End Sub
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all th
the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Thursday, February 4, 2016 5:10 AM, Shrinivas Shevde <
>
Dear All
Please find attached sheet which contain macro.
Basically there is data in sheet Book "Filter Macro".
I need to filter this data on Date basis and filter data need to paste in
new workbook.
Every time filter data then new wokbook will be created.
Now my problem is that its filterd the data
Dear All
Please find attached file which contain macro.
Macro will filter the data date basis (date mentioned in F1 and G1) and
copy paste filtered data in another sheet.
Can anyone help me to modify.
Now I want to creat a new workbook in same folder and copy paste the filter
data.
For eg first I
Really a great job
Very very thanks
Regards
Shrinivas
On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain
wrote:
> Please see attached.
>
> HTH
>
> On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde > wrote:
>
>> Dear Abhishek
>> Thanks for the macros.Its exactl
you need it likewise (make copies once). If you want
> further copies, just change the names in your sheet.
>
> HTH
>
>
> On Sat, Jan 23, 2016 at 11:35 AM, Shrinivas Shevde > wrote:
>
>> Dear Paul,
>> Very very thanks for reply.
>> I may not able to modify
an,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Friday, January 22, 2016 6:54 AM, Shrinivas Shevde <
Dear Experts,
I want a help in macro.
I have a excel sheet as a template.
Now I want to make a multiple sheet with same template.
Currently I am doing it manually like copy sheet and rename the same.
Can Any one write a macro which will ask user no of sheet to be created and
it will creat no of sh
Dear All
Is it possible to Format Filenames With Different Fonts And Colors in excel
If yes plese tell me procedure
--
Shrini
--
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 @
https://www.facebook.com/
Happy new year to all members.
Last year I really got excellent support from all members.
I hope same will be continue .
Special thanks to Noorani sir .
--
Shrini
--
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 th
Dear Abhishek
Thanks sir
Problem Solved
Regards
Shrinivas
On Thu, Dec 31, 2015 at 3:39 PM, Abhishek Jain
wrote:
> The formula is to be used in conditional formatting dialog box only...not
> in B1.
>
> PFA sample attached.
>
> On Thu, Dec 31, 2015 at 3:00 PM, Shriniv
<=TODAY()-15)*
>
>
>
> On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde > wrote:
>
>> Dear all
>> One small query.
>> I have a date in Cell a1 I want to format a cell b1, such that whenver
>> the 15 days over the cell b1 should fill with any colour.
>
Dear all
One small query.
I have a date in Cell a1 I want to format a cell b1, such that whenver
the 15 days over the cell b1 should fill with any colour.
Eg A1 has 10th jan 2015 then cell b1 should fill with any colour on 26th
jan 2015
Is it possible if yes please let me know how to do the same.
Dear Pawan,
Problem solved thanks for help
Regards
Shrinivas
On Sat, Dec 26, 2015 at 9:40 AM, Shrinivas Shevde
wrote:
> Dear Pawan
> Very very thanks I will check on Monday As I am out of office and let you
> know.
> Thanks once again
> Regards
> Shrinivas
>
> On Wed,
Dear Pawan
Very very thanks I will check on Monday As I am out of office and let you
know.
Thanks once again
Regards
Shrinivas
On Wed, Dec 23, 2015 at 5:18 PM, Pawan Yadav wrote:
> Hi Shrini,
>
> Use this formula instead =>
> *=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) *
>
> Problem: ABS f
Vlookup without ABS then I am not getting results for
other.see the first row marked in grey.
Regards
Shrinivas
On Mon, Nov 30, 2015 at 9:57 AM, Shrinivas Shevde
wrote:
> Dear All
> I am using vlookup and facing following problem
> File attached
> thanks in advance
>
> --
> Sh
Dear Mandeep
thanks for reply but I could not understand which format shall I change
which column
Regards
Shrinivas
On Mon, Nov 30, 2015 at 10:34 AM, Mandeep Baluja
wrote:
> Keep the data in same format, number can't be equal to Text and text can't
>> be equal to number,I put the data in same f
Dear All
I am using vlookup and facing following problem
File attached
thanks in advance
--
Shrini
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
Dear All
I Have macro which was running fine for last 2 to 3 years .All of sudden I
am facing problem of" "Run Time Error 13 " I tried to find out but I could
not.
While debugging following line gets highlighted
* If (Sheets("Production").Cells(Data.Row, "Z").Value <> "") Then*
In declaration
+Shift+Enter (not just
> enter) before dragging it down.
>
> Regards,
>
>
> On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde > wrote:
>
>> Dear All
>> Please find query.
>> I have a excel sheet where I store all parts details I received .
>> I want
Dear All
Please find query.
I have a excel sheet where I store all parts details I received .
I want to make a list of all parts .
I cant use remove duplicate function..
Can I get some other way/Formula so that list will keeps on updating as and
when I will add new parts.
Please find attached sheet
;
>> Now As lookup_value 2 is not in above array so it's finding minimum high
>> value, which is 1 and their position.
>> So the value 1's highest position is #15 so it's getting back #15
>> position value from "$B$1:$B$17", "38500".
>&g
Dear Abhi
Can you please explain (1/($A$1:$A$17=F2)
Thanks
Shrinivas
On Thu, Aug 27, 2015 at 4:30 PM, Prafull Jadhav
wrote:
> Great ...
> Abhishekji
>
> Regards,
> Prafull Jadhav
> 9920553518
>
> On 27 August 2015 at 15:51, Pankaj Sharma wrote:
>
>> Thank you Abhishek Jain
>>
>> On Th
Dear all
I wanta template in Excel for maintaining chemicals inventory.
If any one have template please send it to me
Thanks in advance.
--
Shrini
--
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
Dear Experts
I have a table for tracking project in column I mentioned the steps in
project and in row the name of the project . In table I mentioned dates .
I want whenever I put any date then there should be list of all work for
that day.
Actually it will be better if I get From and to date inst
t; =--MID(A9,FIND(1,A9,1),6)
>
> On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde
> wrote:
>
>>
>> Dear All
>>
>> I have a text in Column A4 ,I am extracting a number from that text in
>> colum B4,using outcome of I want to use Vlookup but its not successf
Dear All
I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome of I want to use Vlookup but its not successful.
Same Out put I entered by hand in the column then I get desire result.
To entered manually its take lot of time I have more than 1000 data.
Please
n Wed, Feb 4, 2015 at 10:30 AM, Shrinivas Shevde
> wrote:
>
>> Dear Paul/Vaibhav
>> Thanks for reply.
>>
>> *To Vaibhav,*
>> Macro you send is just merging the data from all sheets in one sheet.My
>> requirement is something different which I tried to explain be
doubt please ask
Thanks once again
Regards
Shrinivas
On Tue, Feb 3, 2015 at 6:42 PM, Vaibhav Joshi wrote:
> Hi
>
> Use this sheet to merge all sheets data in one sheet..
>
> Cheers!!
>
> On Tue, Feb 3, 2015 at 1:02 PM, Shrinivas Shevde
> wrote:
>
>> Dear All
&
Dear All
Please help me for following problem
I used to get the data in 2 sheets Trial1 and Trial 2
I need to conoslidate this data in 3rd sheet "results"
It is very time consuming process.As I need to insert row after every row
of Trial 1 and copy paste from Trial 2 (there are more than 150 lines
Dear Paul
Yesterday I tried and now problem is solve but still I could not loacte the
problem its got solve just by luck.
Regards
Shrinivas
On Fri, Jan 16, 2015 at 10:25 AM, Shrinivas Shevde
wrote:
> Dear Paul
> Very very thanks for reply.
> I will follow the steps and wil come back b
t;
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*Fro
ue
> End If
> Next Data
> '--
> tstop = Timer
> tElapsed = tstop - tstart
> tMin = tElapsed \ 60
> tSec = tElapsed Mod 60
> MsgBox "Finished" & Chr(13) & tMin & "
Dear all
I have a excel sheet in which cells are coloured on some basis (manually)
I want to do some calculation based on colour
Please find attached Sheet
--
Shrini
--
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 o
Dear All
Please find below macro.
Previously it was running very fine but from last few days it takes time (2
to 3 min).I could not trace out can any one help me for finding out
problem.
Macro is just for copying some data from one sheet and paste to other shhet
and removes unwanted column
Sub B
I wish to find out difference between two dates in terms of Months.
e.g. 10th May 2014 & today = 3 months
10th May 1993 & today = 255 months
10th jan 1981 & today = 403 months
--
Shrini
--
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) ! Joi
Dear Vaibhav
After running macro try to shift heading & you can see data is copied below
heading
Can u please how to do the same
Regards
shrinivas
On Thu, Jun 12, 2014 at 10:35 AM, Shrinivas Shevde
wrote:
> Dear Be Tran Van
> Thanks for kind help will check today and back
Dear Be Tran Van
Thanks for kind help will check today and back by evening
regards
Shrinivas
On Thu, Jun 12, 2014 at 10:28 AM, Shrinivas Shevde
wrote:
> Dear Vaibhav
> First of all thanks for the help.
> I was out of station for 2 days so I could not reply sorry for that
> I wi
>
>>> Cheers!!
>>>
>>>
>>>
>>> On Mon, Jun 9, 2014 at 6:23 PM, Vaibhav Joshi wrote:
>>>
>>>> ok..
>>>>
>>>> I will try to send you by tonight..
>>>>
>>>> Cheers!!
>>>>
>>>>
Dear all
Can I have multiple axis in a graph (more than 2)
I want to have a graph having values ranging ( .1 to 1.2,65 to 75, 150 to
168)
Thanks in advance
--
Shrini
--
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
d
> sheet.
>
> Cheers!!
>
>
>
> On Sat, Jun 7, 2014 at 10:32 AM, Shrinivas Shevde
> wrote:
>
>> can anyone help me?
>> Thanks in advance
>>
>>
>> On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde > > wrote:
>>
>>> Dear All
>
Cant understand what is this attachment
On Sat, Jun 7, 2014 at 4:07 PM, Vaibhav Joshi wrote:
> FYI
>
>
> On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde
> wrote:
>
>> Dear Vaibhav
>> Where is attachment
>>
>> Regards
>> Shrinivas
>>
>
Dear Vaibhav
Where is attachment
Regards
Shrinivas
On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:
> hi
>
> check this..
>
> It is dynamic..
>
> CHeers!!
>
>
> On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde
> wrote:
>
>> Dear All
>> P
can anyone help me?
Thanks in advance
On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde
wrote:
> Dear All
> Please help me for Macro
> 1. I have a work book which content many sheet.
> 2.In a work book there is data sheet.(master sheet) sheet attached
> 3.In a master sheet ther
Dear All
Please help me for Macro
1. I have a work book which content many sheet.
2.In a work book there is data sheet.(master sheet) sheet attached
3.In a master sheet there is data which content 5 field
4.I want to transfer the data Deptwise.
5.Order of the column is not same in master sheet and
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote:
> Hi
>
> PFA
>
> All data will be merged into Result sheet, with sheets name in first col.
>
> Cheers!!
>
>
>
> On Sat, May 31, 2014 at 11:51 AM, Shr
Dear all
I have a macro in which there are many sheet .
I want all data of all sheet in one sheet .Columns are same in all sheet
rows are varying.
Data should be paste one below another.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=T
thanks problem solved
On Sat, May 10, 2014 at 12:34 AM, ashish koul wrote:
> wht do u wanna do .. its x y scatter chart
>
>
> On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde
> wrote:
>
>> Dear All
>> I received one excel file in whih there is a graph.
>>
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
> Hi
>
> Yes you can paste data in master file below the existing data. However you
> can test data.
>
>
> Thanks
>
>
> On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde
> wrote:
>
&
eers!!
>
>
> On Mon, May 5, 2014 at 3:51 PM, Shrinivas Shevde
> wrote:
>
>>
>> Dear all
>>
>> I am getting a data on daily basis.In which there are various items and
>> items code.Item code is changing on daily basis.I have to make itemwise
>>
Dear sir,
Thanks for reply but I want perfectly opposite.
Thats I have a master sheet and from that it should go to indivisual sheet.
Regards
Shrinivas
On Mon, May 5, 2014 at 8:10 PM, Bé Trần Văn wrote:
> Reference File.
>
> 2014-05-05 17:21 GMT+07:00 Shrinivas Shevde :
>
&
Dear all
I am getting a data on daily basis.In which there are various items and
items code.Item code is changing on daily basis.I have to make itemwise
sheet an dneeds to copy paste the items code.
Is it possible to write a code so that wheneve i clicked on a button all
items code wil go to corre
Please find attacehd Sheet
--
Shrini
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
Dear All
I have a graph having 6 series in Sheet 1.
I want to copy the same graph in sheet 2 .I just copy paste the graph but
it takes the data from Sheet 1 only.Is there any way to copy the graph so
that it takes the data from sheet 2 (Data range is same as sheet 1)
Thanks in advance
--
Shrini
Dear Ravindra
Problem solved really great help
Thanks
Regards
Shrinivas
On Sat, Mar 15, 2014 at 3:56 PM, Ravinder wrote:
> U can use f2 then paste
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *S
Dear All
I want to copy 3 lines group from PDF and want to paste in EXcel.(such I
have more than 60 )
When I paste in excel its paste in 3 rows
Is there any trick or idea so that this will get paste in one cell only
Regards
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
egroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* Thursday, February 13, 2014 9:28 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Help on sumif function
>
>
>
>
> Dear All,
>
>
>
> Please find
Dear All,
Please find attached sheet
--
Shrini
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thre
dition, some values are coming as #N/A. What to
> do with those?
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde
> wrote:
>
>> Dear all
>> I want to subtract one date from another (file attached )
>> Can anyone
Dear all
I want to subtract one date from another (file attached )
Can anyone help me
I think for the date format is not same
Regards
Shrini
--
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 @
https://ww
Thanks sir
Really great job
Problem Solved
Thanks once again
Regards
Shrinivas
On Fri, Nov 29, 2013 at 12:40 PM, Ravinder wrote:
> PFA…I think u r looking for this….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrini
ards
Shrinivas
On Thu, Nov 28, 2013 at 12:37 PM, Ravinder wrote:
> Pfa….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* Thursday, November 28, 2013 11:53 AM
> *To:* excel-macros@googlegroups.
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde wrote:
> Dear all
> I have excel sheet in which I added comments in many cell.
> I want to get all the comments in row one below another may be any order.
> In one sheet there are more than 40 comments and such
Dear all
I have excel sheet in which I added comments in many cell.
I want to get all the comments in row one below another may be any order.
In one sheet there are more than 40 comments and such I have 16 to 18
sheets
Can any one help me to write code which will do this.
Sheet is attached
--
S
Thanks to all problem solved
On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde wrote:
> Dear Kartik
> thans adn appretiate for the effort.
> for the example its ok but for actual it will not work as in actual Column
> B and Column D are totally different in column B there is
Dear shakeel
thanks
problem solved great Help
Regards
Shrinivas
On Thu, Nov 21, 2013 at 1:51 PM, Shakeel Dhanani wrote:
>
> You can use Index Match formula instead of VLookup as per Fiel atatched
>
> On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote:
>>
>> Dear All
>> Please find at
.in this case we can not use REPT function.
Regards
Shrinivas
On Wed, Nov 20, 2013 at 5:51 PM, Kartik Dale wrote:
> Hi Shrinivas,
>
> PFA, Let me know if you need any changes required
>
> Regards,
> Cartik
>
>
> On Wed, Nov 20, 2013 at 5:10 PM, Shrinivas She
Can u explian more please
On Wed, Nov 20, 2013 at 5:31 PM, Ravinder wrote:
> Then you can use Match function to get the column number and put in yellow
> colored..
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On
:
> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* Wednesday, November 20, 2013 5:11 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Vlookup query
>
>
>
>
Dear All
Please find attached query.
Is it possible to write aformula as per my requirement
--
Shrini
--
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 @
https://www.facebook.com/discussexcel
FORUM RU
Dear Vinay
Thanks for reply
Actually I want to sum of more than 40 column
Regards
Shrinivas
On Mon, Nov 11, 2013 at 5:51 PM, Vinay Saraf wrote:
> You can use vlookup or sumif 3 times and add all three
> On 11 Nov 2013 17:27, "Shrinivas Shevde" wrote:
>
>> Dear All
&g
Dear All
In vlookup we are giving the column no from which value should be picked up
.
I want to get the summation of 3 column is it possible?
For Eg
I want to get the summation of column 9,10,12
Can anyone tell me how to do it
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Dear All
When I open workbbok I used to receive following message
Please let me know how to find uot the link
v[image: Inline image 1]
Thanks in Advance
--
Shrini
--
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
dear Ravindra
very very thanks
Regards
Shrinivas
On Sat, Sep 21, 2013 at 4:53 PM, Ravinder wrote:
> PFA…(SECOND BUTTON FOR DELETING ROWS)
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* Saturday, September 21, 2013 12:46 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Help for Copy paste
>
> ** **
>
>
&
Dear All
I am facing problem in find out blank cell at one go ,because that cell
content formula.
Please find attached sheet
Thaks in avance
--
Shrini
--
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 @
ay, September 14, 2013 10:03 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Query on vlookup
>
> ** **
>
> Try this formula
>
> *=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)*
>
> On 14-09-2013 11:28, Shrinivas Shevde wr
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use c
"*.xls; *.xlsx; *.xlsm; *.xlsb", 1
>>
>> Warm Regards,
>> Gawli Anil
>>
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>>
>> On Mon, Aug 19, 2013 at 2:24 PM, Shriniv
Dear Ahsish
waiting for help
Regards
Shrinivas
On Sat, Aug 17, 2013 at 11:50 AM, Shrinivas Shevde
wrote:
> Dear Ashish
> Please find attached File
>
> Regards
> Shrinivas
>
>
> On Sat, Aug 17, 2013 at 9:41 AM, ashish koul wrote:
>
>> Hi can u share some
Dear Indarjit
Can you share a file with me because I have the same work
Regards
Shrinivas
On Mon, Aug 19, 2013 at 2:33 PM, Indrajit $nai wrote:
> Thanks a lot to both of you.
>
> You guys are simply awesome :)
>
>
> On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote:
>
>> add below "M
Dear All
I am facing a small problem I like to have help for expert.
I am trying to write a macro which will browse the folder and open the
selected file one by one.
But whenever I am opening a folder from macro I could not see any file in
that folder.
If I am opening the same folder directly there
Dear Ashish
I try this macro but there is a samll pr
oblem when I open folder folder shows empty .actually there are 3 to 4
excel worksheets in the folder
Regards
Shrinivas
On Fri, Aug 16, 2013 at 8:48 AM, Shrinivas Shevde wrote:
> Dear ashsish
> Thanks for reply I will run the same an
WKB.Sheets(1).Range("b5:b20").Copy _
>
> Destination:=ThisWorkbook.Sheets(1).Range("a65356").End(xlUp).Offset(1, 0)
> WKB.Close , False
> End If
> Next
>
> End Sub
>
>
>
> On Wed, Aug 14, 2013 at 5:18 PM, Shrinivas Shevde
> wrot
Dear All
I want a macro for following
1. I receives workbook (4 to 5) every week
2.Work book contains only one sheet
3.I stores all this in a folder
4.I want a macro which will open folder and open workbook one by one
5.Copy a particular range (eg Range B5 To B20) from every workbook
6. Paste all
> On Tue, May 21, 2013 at 2:17 PM, Shrinivas Shevde
> wrote:
>
>> Waiting for Reply
>>
>>
>> On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde > > wrote:
>>
>>>
>>> Dear All
>>>
>>> Please find atached excel sheet contai
Waiting for Reply
On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde wrote:
>
> Dear All
>
> Please find atached excel sheet contain data .
> I want to make a Dynamic graph(as far a possible without macro) for users
> as the users is of top level I dont want to show any d
Dear All
Please find atached excel sheet contain data .
I want to make a Dynamic graph(as far a possible without macro) for users
as the users is of top level I dont want to show any data.I want to show
only a graph. Users should have a multiple choice to view a graph
.For example
1. Graph only fo
Dear Abhishek
Its really helpful (site and the draft)
You said it rightly here are many Excel master who are ready to help for
all your problem and as per my experience you will get more than one
solutiion for any problem
Once again thanks for site and draft
Dear Chhaya
I am not expert in Macro but
ear Rajan/Praful
Please find attched Sheet
Regards
Shrinivas
On Sat, Apr 6, 2013 at 3:51 PM, prafull jadhav wrote:
> Please share a example file with criteria
>
>
> On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde
> wrote:
>
>>
>> Dear All
>> Can Anyone an
1 - 100 of 189 matches
Mail list logo
