Re: $$Excel-Macros$$ Macro for Copy Paste

letely. > > Thanks > Kishore > > On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde <shrinivas...@gmail.com> > wrote: > >> Dear All >> >> I have a work book which contain many daywise sheet in which I maintain >> machinewise data. >> I have 20 ma

Re: $$Excel-Macros$$ Macro for Copy Paste

Can Anyone please help me? On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde <shrinivas...@gmail.com> 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 runnin

$$Excel-Macros$$ Macro for Copy Paste

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

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

ot; sec" > MsgBox msg > 'xxxxxxxx > xxx > End Sub > > > *Paul* > - > > > > > > > > *“Do all the good you

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

> > > > > > > > *“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* > ---

Fwd: $$Excel-Macros$$ Macro for Copy Paste

Dear Friends Waiting for reply -- Forwarded message -- From: Shrinivas Shevde <shrinivas...@gmail.com> 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

$$Excel-Macros$$ Macro for Copy Paste

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

Re: $$Excel-Macros$$ Copy Paste Problem

t the range where code is running, 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 <shrinivas...@gmail.com> > wrote: > >> Dear Sir >> Thanks for Prob

Re: $$Excel-Macros$$ Copy Paste Problem

Hi Shrini, > > Please check the 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 <shrinivas...@gmail.com> > wrote: > >> Dear all >> I have data in

$$Excel-Macros$$ Copy Paste Problem

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

Re: $$Excel-Macros$$ Help for macro

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* > - > > > On Thursday, February 4, 2016 5:1

Re: $$Excel-Macros$$ Help for macro

> 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 the people > you can,As long as ever you can.” - J

$$Excel-Macros$$ Modification of macro

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

Re: $$Excel-Macros$$ Create Multiple sheet

Really a great job Very very thanks Regards Shrinivas On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain <abhishek@gmail.com> wrote: > Please see attached. > > HTH > > On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde <shrinivas...@gmail.com > > wrote

Re: $$Excel-Macros$$ Create Multiple sheet

error. > > I gathered that 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 <shrinivas...@gmail.com > > wrote: > >> Dear Paul, >&g

$$Excel-Macros$$ Create Multiple sheet

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

Re: $$Excel-Macros$$ Create Multiple sheet

; *“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* > ----- > > > On Friday, January 22

$$Excel-Macros$$ File name colour

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 @

Re: $$Excel-Macros$$ formatting cell

ND(A1<>"",A1<=TODAY()-15)* > > > > On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde <shrinivas...@gmail.com > > wrote: > >> Dear all >> One small query. >> I have a date in Cell a1 I want to format a cell b1, such that whenver &g

Re: $$Excel-Macros$$ formatting cell

t;> wrote: >> >>> You can use below formula in B1 and set desired format. Then copy B1 and >>> select rest of the cells where you want the formatting and use Paste >>> Special > Formats. >>> >>> *=AND(A1<>"",A1<=TODAY()-

$$Excel-Macros$$ Happy new year

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

$$Excel-Macros$$ formatting cell

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.

Re: $$Excel-Macros$$ Re: VLOOKUP Query

Dear Pawan, Problem solved thanks for help Regards Shrinivas On Sat, Dec 26, 2015 at 9:40 AM, Shrinivas Shevde <shrinivas...@gmail.com> 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 &

Re: $$Excel-Macros$$ Re: VLOOKUP Query

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 => >

Re: $$Excel-Macros$$ VLOOKUP Query

the 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 <shrinivas...@gmail.com> wrote: > Dear All > I am using vlookup and facing following problem > File attached >

$$Excel-Macros$$ VLOOKUP Query

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

Re: $$Excel-Macros$$ Re: VLOOKUP Query

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

$$Excel-Macros$$ Type Mismatch error

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

Re: $$Excel-Macros$$ need Excel formula

highest position is #15 so it's getting back #15 position value from $B$1:$B$17, 38500. On Thu, Aug 27, 2015 at 5:13 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: 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

$$Excel-Macros$$ Formula needed

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

Re: $$Excel-Macros$$ Formula needed

Ctrl+Shift+Enter (not just enter) before dragging it down. Regards, On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: 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

$$Excel-Macros$$ Required formula /code

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

Re: $$Excel-Macros$$ Vlookup query

on that value. =--MID(A9,FIND(1,A9,1),6) On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde shrinivas...@gmail.com 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 successful. Same Out put I

$$Excel-Macros$$ Vlookup query

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.

Re: $$Excel-Macros$$ Data handling

, Shrinivas Shevde shrinivas...@gmail.com 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 below To Paul, Do you have any experience with macros? *Yes

Re: $$Excel-Macros$$ Data handling

please ask Thanks once again Regards Shrinivas On Tue, Feb 3, 2015 at 6:42 PM, Vaibhav Joshi v...@vabs.in 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 shrinivas...@gmail.com wrote: Dear All Please help me

$$Excel-Macros$$ Data handling

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 )

Re: $$Excel-Macros$$

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 shrinivas...@gmail.com wrote: Dear Paul Very very thanks for reply. I will follow the steps and wil

Re: $$Excel-Macros$$

* - *From:* Shrinivas Shevde shrinivas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, January 15, 2015 1:14 AM *Subject:* Re: $$Excel-Macros$$ Dear Paul Till date code was runing fine I added one column after Column B and made required

Re: $$Excel-Macros$$

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* - *From:* Shrinivas Shevde shrinivas...@gmail.com *To:* अनिल नारायण गवली

$$Excel-Macros$$ Value based on Cell Background colour

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

$$Excel-Macros$$

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

$$Excel-Macros$$ Help for date formula

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) ! Join

$$Excel-Macros$$ Graph Query

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

Re: $$Excel-Macros$$ Help for Macro

, 2014 at 12:08 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Vaibhav Thanks for reply. As I mentioned earlier today I have 10 rows and I run the macro. I will get output. Tomorrow I will add more 12 rows and if I run the macro I will get output and it will overwrite the last one

Re: $$Excel-Macros$$ Help for Macro

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 shrinivas...@gmail.com 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

Re: $$Excel-Macros$$ Help for Macro

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 shrinivas...@gmail.com wrote: Dear Be Tran Van Thanks for kind help will check today and back

Re: $$Excel-Macros$$ Help for Macro

Dear Vaibhav Where is attachment Regards Shrinivas On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this.. It is dynamic.. CHeers!! On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear All Please help me for Macro 1. I

$$Excel-Macros$$ Help for Macro

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

Re: $$Excel-Macros$$ Help for Macro

can anyone help me? Thanks in advance On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde shrinivas...@gmail.com 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

$$Excel-Macros$$ Macro Required

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

Re: $$Excel-Macros$$ Macro Required

Dear Vibhav Good Work Very very thanks Regards Shrini On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi v...@vabs.in 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, Shrinivas Shevde shrinivas

Re: $$Excel-Macros$$ Macro required

Very very thanks On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in 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 shrinivas...@gmail.comwrote: Dear Vaibhav

Re: $$Excel-Macros$$ Macro required

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 betnmtdongna...@gmail.comwrote: Reference File. 2014-05-05 17:21 GMT+07:00 Shrinivas Shevde

Re: $$Excel-Macros$$ Macro required

!! On Mon, May 5, 2014 at 3:51 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: 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

$$Excel-Macros$$ Macro required

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

$$Excel-Macros$$ Copy Graph

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

$$Excel-Macros$$ Copy paste from PDF File

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

Re: $$Excel-Macros$$ Copy paste from PDF File

Dear Ravindra Problem solved really great help Thanks Regards Shrinivas On Sat, Mar 15, 2014 at 3:56 PM, Ravinder ravindervbacli...@gmail.comwrote: U can use f2 then paste *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent

$$Excel-Macros$$ Help on sumif function

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

Re: $$Excel-Macros$$ Help on sumif function

] *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 attached sheet -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

$$Excel-Macros$$ Date Substraction

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 @

Re: $$Excel-Macros$$ Date Substraction

? In addition, 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 shrinivas...@gmail.comwrote: Dear all I want to subtract one date from another (file attached ) Can anyone help me I think for the date

Re: $$Excel-Macros$$ Comments

Of *Shrinivas Shevde *Sent:* Friday, November 29, 2013 11:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Comments Dear Ravindra Pankaj Marvelous job done ,really great. Can I get little more help With the current solution provided by both of you is working fine

Re: $$Excel-Macros$$ Comments

Shrinivas On Thu, Nov 28, 2013 at 12:37 PM, Ravinder ravinderexcelgr...@gmail.comwrote: 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.com *Subject

$$Excel-Macros$$ Comments

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 --

Re: $$Excel-Macros$$ Comments

Waiting for Reply On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Vlookup query

.in this case we can not use REPT function. Regards Shrinivas On Wed, Nov 20, 2013 at 5:51 PM, Kartik Dale kartik.1...@gmail.com 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 Shevde shrinivas

Re: $$Excel-Macros$$ Re: Vlookup query

Dear shakeel thanks problem solved great Help Regards Shrinivas On Thu, Nov 21, 2013 at 1:51 PM, Shakeel Dhanani dhanan...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Vlookup query

Thanks to all problem solved On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: 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

$$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

Re: $$Excel-Macros$$ Vlookup query

ravinderexcelgr...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Vlookup query

Of *Shrinivas Shevde *Sent:* Wednesday, November 20, 2013 5:29 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Vlookup query Dear Ravindra thanks for reply VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7), COLUMN(B$1),0) In the above formula

$$Excel-Macros$$ VLOOKUP Query

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

Re: $$Excel-Macros$$ VLOOKUP Query

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 vi...@vinaysaraf.com wrote: You can use vlookup or sumif 3 times and add all three On 11 Nov 2013 17:27, Shrinivas Shevde shrinivas...@gmail.com wrote

$$Excel-Macros$$ Message in Excel

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

Re: $$Excel-Macros$$ Help for Copy paste

dear Ravindra very very thanks Regards Shrinivas On Sat, Sep 21, 2013 at 4:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA…(SECOND BUTTON FOR DELETING ROWS) ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde

$$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

Re: $$Excel-Macros$$ Help for Copy paste

** ** *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

$$Excel-Macros$$ Query on vlookup

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

Re: $$Excel-Macros$$ Query on vlookup

: $$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 wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini

Re: $$Excel-Macros$$ Folder Query (urgrnt)

, Aug 19, 2013 at 2:24 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: 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

$$Excel-Macros$$ Folder Query (urgrnt)

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

Re: $$Excel-Macros$$ Need urgent help on macro error.

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 talk2indra...@gmail.comwrote: Thanks a lot to both of you. You guys are simply awesome :) On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi

Re: $$Excel-Macros$$ Macro for COPY Paste

Dear Ahsish waiting for help Regards Shrinivas On Sat, Aug 17, 2013 at 11:50 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Ashish Please find attached File Regards Shrinivas On Sat, Aug 17, 2013 at 9:41 AM, ashish koul koul.ash...@gmail.comwrote: Hi can u share some sample

Re: $$Excel-Macros$$ Macro for COPY Paste

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 shrinivas...@gmail.comwrote: Dear ashsish Thanks for reply I will run

Re: $$Excel-Macros$$ Macro for COPY Paste

) And fil.Name ThisWorkbook.Name Then Set WKB = Workbooks.Open(fil.Path) 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

$$Excel-Macros$$ Macro for COPY Paste

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

Re: $$Excel-Macros$$ Dynamic Graph Help

sense? On Tue, May 21, 2013 at 2:17 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Waiting for Reply On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear All Please find atached excel sheet contain data . I want to make a Dynamic graph(as far

Re: $$Excel-Macros$$ Dynamic Graph Help

Waiting for Reply On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: 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

$$Excel-Macros$$ Dynamic Graph Help

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

Re: $$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$

ear Rajan/Praful Please find attched Sheet Regards Shrinivas On Sat, Apr 6, 2013 at 3:51 PM, prafull jadhav prafulltjad...@gmail.comwrote: Please share a example file with criteria On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All Can Anyone answer

Re: $$Excel-Macros$$

Dear All Can Anyone answer this Regards Shrinivas On Mon, Apr 1, 2013 at 1:48 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Rajan Thanks for reply Column E,F -: May be blank if there is value Character should not be greater than 60 Column G -: Should not be blank

Re: $$Excel-Macros$$

: Column E,F -: May be blank if there is value Character should not be greater than 60 Column F -: Should not be blank and Character should not be ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 30 March

$$Excel-Macros$$

Dear All I want to write a formula to check Following condition if all the following condition fulfilled then resulta should be ok. Condition- - Column A -:Should not be blank and Character should not be greater than 5 - Column B,C,D -:Should not be blank and Character should not be

Re: $$Excel-Macros$$ Fwd: URGENT PLS HELP ME IN EXCEL WORK

Dear Kannam Can u explain it more? if possible with Example Regards Shrinivas On Wed, Mar 6, 2013 at 10:33 AM, kannan excel kannan.ex...@gmail.comwrote: PLS HELP ME -- Forwarded message -- From: kannan excel kannan.ex...@gmail.com Date: Tue, Feb 26, 2013 at 11:59 AM

Re: $$Excel-Macros$$ If condition

Dear Prabhakar Please clear Following things 1.What is full year (how much Bonus wage is full year) 2.In body of mail u r showing greater than 1 but in Sheet u r writing less than 1 3.What is prorata basis Regards Shrinivas On Mon, Mar 11, 2013 at 4:03 PM, Prabhakar S H

Re: $$Excel-Macros$$ calculating between two cells in two different sheets.

Dear Jaz Please find attached file. Is it om Please let me know. Regards Shrinivas On Fri, Mar 8, 2013 at 2:30 AM, Jaz jazb...@gmail.com wrote: Hello all, I am wondering if I can be helped in this. I have two sheets 'Main' 'Consumed' B col. of both sheets have Lot ID. A macro should be

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi ravi_colw...@yahoo.comwrote: there is no sheet --- On *Fri, 3/8/13, Jaz jazb...@gmail.com* wrote: From: Jaz jazb...@gmail.com Subject: $$Excel-Macros$$ Re: calculating between two cells in two different sheets. To:

  1   2   >