Re: $$Excel-Macros$$ Re: Required the file like the output file.

Try this code.. Sub test() Application.ScreenUpdating = False Dim sh As Object Dim i As Integer Dim nwkb As Object Dim lrow As Long Set nwkb = Workbooks.Add nwkb.Sheets(1).Cells(1, 1).Value = Date nwkb.Sheets(1).Cells(1, 2).Value = Emp code nwkb.Sheets(1).Cells(1, 3).Value = Time

Re: $$Excel-Macros$$ Re: Required the file like the output file.

Hi Anil, You did not mention the Outtime in your Output sheet..following heading are there in that sheet Date Emp code Time DDMM HHMM Empcd Final output -- 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

Re: $$Excel-Macros$$ Re: Required the file like the output file.

Try this one.. Sub test() Application.ScreenUpdating = False Dim sh As Object Dim i As Integer Dim nwkb As Object Dim j As Long Dim lrow As Long Set nwkb = Workbooks.Add nwkb.Sheets(1).Cells(1, 1).Value = Date nwkb.Sheets(1).Cells(1, 2).Value = Emp code nwkb.Sheets(1).Cells(1, 3).Value = Time

$$Excel-Macros$$ Re: Need help in forecast

Hi Prabhu, I can help you if you can share data with me... On Wednesday, September 18, 2013 8:59:41 AM UTC+5:30, prabhupink80 wrote: Hi Experts, i have historical pattern of last few month daywise daily offered. is there possible to calculate the next month overall volume by using excel.

$$Excel-Macros$$ Excel Formula..Sumproduct..

Hi all, I want total Calories of Snickers and Potato from below data ..Output is 1150, please solve.. *ColumnA ColumnB Column C Column D* Candy Calories Fruits Vegetables Calories Snickers 350 Tomato 10 Twix 370 Potato 40 Skittles 450 Tomato 30 Snickers

$$Excel-Macros$$ Re: how to insert Excel File in powerpoint presentation...

*Hi Dhananjay, Do not use it as hyperlink..better go to insert click on object..then create from file..browse your file and then click on display as icon..click ok.. Hope this will help you out.. * -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

Hi Dnananjay, As you said there is no Network between computer, So you need to put the Excel file on same location on another computer as mention in Hyperlink address. Without saving excel file on another system, you can not use it. Otherwise you can Attach the excel file on Powerpoint That

$$Excel-Macros$$ Re: Different Validateion

*select Cell B1 and Go to Datavalidation then select Custom and put this formula..=ISTEXT(B1) * -- 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)

$$Excel-Macros$$ New here

*I am Deepak Singh, i have been referred to this group by one of my friend who is already part of this group. I am also part of some other Excel Forumn. Hope i will learn many thing from this group and get solution from all experts related to my Excel related issues. Thanks Regards Deepak

Re: $$Excel-Macros$$ New here

Thanks Priti and DP i am also feeling the same to see you type of great Excel Experts in this group. now i can say I will enjoy in this group and give all my support. -- 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