RE: $$Excel-Macros$$ Re: Copy data to next empty row

Hi, Ok, please see the below code, if still it's not fine then let me know Sub findlastrow() Dim rng As Range Set rng = Range("A37:A115 ") For Each c In rng If c.Value = "" Then storeval = c.Row MsgBox storeval Exit Sub End If Next End Sub Warm Re

Re: $$Excel-Macros$$ counting of a particular denomination

Dear Anil, Thanks for your prompt response. However, I also need solution for second query i.e If I wish to calculate number of pieces for each of them, how could i do that using a formula. On Fri, Aug 30, 2013 at 12:22 PM, अनिल नारायण गवली wrote: > Dear Kushlesh, > > > You can u with countifs

RE: $$Excel-Macros$$ Copy data to next empty row

Hi, Sorry about that but your question is still not clear to me. Could u plz send me Screen shot in excel or any excel files if you have. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dante Julian Sent: Friday, A

Re: $$Excel-Macros$$ counting of a particular denomination

Dear Kushlesh, You can u with countifs(criteriarange,criteria) and enter Pl find the attached sheet Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama wrote: > Dear Team, > > Please f

$$Excel-Macros$$ Re: Copy data to next empty row

Dear Experts, Thank you for your quick replies. Sorry, if my question was not clear. What I wanted to find is the last row within the range A37:A115 of the first workbook. Again, thank you. DanJ On Friday, August 30, 2013 12:39:15 PM UTC+8, DanJ wrote: > > Dear Experts, > > I have a range

Re: $$Excel-Macros$$ Copy data to next empty row

Hi, Thank you for your quick reply. I'm sorry if my question wasn't clear. What I wanted to find is the next empty row in the first workbook in the range A37:A115 , i.e., after  I copied and pasted thereon the data from the second workbook. Again, Thank you. DanJ _

$$Excel-Macros$$ counting of a particular denomination

Dear Team, Please find the attached Excel File. I have two queries; 1. I have certain denomination in range A3:A10. If I wish to know the number of times a denomination has appeared which formula should i use? 2. Adjacent to those denominations there are certain amount of pieces of that denominati

Re: $$Excel-Macros$$ Copy data to next empty row

try below code i = WorksheetFunction.CountA(Range("a:a")) + 1 Range("a" & i).Select . Enjoy Team XLS On Fri, Aug 30, 2013 at 10:09 AM, DanJ wrote: > Dear Experts, > > I have a range, * A37:A115,* in my first (1st) workbook where I copy > and paste data from my seco

RE: $$Excel-Macros$$ Copy data to next empty row

Hi, Find out the last row of third workbook/sheet, Workbooks("book3").Activate Worksheets("sheet3").activate Finalrow = cells(rows.count,1).end(xlup).row Range("A"&finalrow+1).select Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegrou

$$Excel-Macros$$ Copy data to next empty row

Dear Experts, I have a range, * A37:A115,* in my first (1st) workbook where I copy and paste data from my second and third workbook, respectively. Since the number of rows to be copied from the *second workbook* vary daily, the next empty row in range *A37:A115* of the first workbook change

$$Excel-Macros$$ Excel File Date Contents Deletion Macro

Dear All, I want to create a excel file with Date limit. Like in a file there are some contents(Graphs, Dashboards Etc) with 3 sheets. What i wants is after a time period like 31-Aug13 it gets expired and no one can open it or if someone opens after 31-Aug-13 it will delete all the file content

Re: $$Excel-Macros$$ Calculate expirationDate based on CreationDate and Number

Yes Keep in mind that the DATE is simply a number, displayed in Date format.   So, your date: 1/1/2013 is really 41275 (the number of days since 1/1/1900)   So, your "Expiration Date" is 41275 + 30, or 41305 which is DISPLAYED as 1/31/2013   a Macro would would similarly: Sub ExpDate()     Dim

Re: $$Excel-Macros$$ Counting the number of times in a range

Are the "times" actual EXCEL TIME or a string?   If it's ACTUAL Excel time, then the values are actually numbers. That is, the fractional part of a day.   6:00am is .25 6:00pm is .75   So, to determine how many values are between 7:00am and 7:59am, you're actually wanting to count the number of val

$$Excel-Macros$$ Counting the number of times in a range

Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for example. I need to count how many times occur in a range. So 7:00-7:59 occurs twice 8am-8:59 occurs once. I have tried a count if function but it didin't work. I must be entering something wrong. -- Are you =EXP(E:RT) or =N

$$Excel-Macros$$ Calculate expirationDate based on CreationDate and Number

TapeLabel SerialNo CreationDate SaveFactor ExpirationDate HostName PRDB0101 OP0025 01/01/2013 30 PRD I would like to populate the ExpirationDate by Calculating using CreationDate + SaveFactor. Is this possible using a macro? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

$$Excel-Macros$$ Exporting data - Excel to Excel

Dear Experts I Need your help! 1 - I have a "DataBase" Excel File that i store some information. 2 - I have an another excel file that register information. I need to send the new information to the database excel file without opening it. Seems to be the same as a Consulting Query, but the inve

Fwd: $$Excel-Macros$$ Very important document

Dear Team XLS Is this a secure email? as i got some security warning. Please confirm. Regards Pravin Gunjal. -- Forwarded message -- From: xlstime Date: Thu, Aug 29, 2013 at 5:58 PM Subject: $$Excel-Macros$$ Very important document To: Good day, Please view the document I up

$$Excel-Macros$$ Very important document

Good day, Please view the document I uploaded for you using Google docs. CLICK HERE just sign in with your email respectively to view the document It's very important Thank You . Enjoy Team XLS -

$$Excel-Macros$$ Worksheet to Master - Row consolidation

Dear Experts. Need your help. the solution can be by using the macros. I have a workbook containing sheet called Indent and master sheet. Indent sheet is form. The contents of the indent sheet to be updated to master sheet in a particular fashion by capturing information of the indent sheet in

$$Excel-Macros$$ Re: Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new sheet

If possible export weekly column also to a separate sheet .Eg name of the month ,weekly percentage, and monthly percentage, in same sheet and also name of month and monthly percentage in different sheet. Thanks On Thursday, 29 August 2013 16:47:42 UTC+5:30, Dhamo dharan wrote: > > U c

Re: $$Excel-Macros$$ need help to create Manpower Assigning report

Template for Manpower as assigning report. On Thursday, 29 August 2013 15:55:12 UTC+5:30, XLS S wrote: > > what you want?.. > > . > > Enjoy > Team XLS > > > > On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan > > wrote: > >> Dear Friends >> >> kindly hep me to create a manpow

Re: $$Excel-Macros$$ need help to create Manpower Assigning report

what you want?.. . Enjoy Team XLS On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan wrote: > Dear Friends > > kindly hep me to create a manpower assigning report. > > E.g: > > *Project name *:xx > *Input:* > *Per day target*:according to project name its should target val

$$Excel-Macros$$ Re: Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new sheet

If it possible please attach sample data so that we can help you On Thursday, 29 August 2013 14:38:39 UTC+5:30, Dhamo dharan wrote: > > Dear Friends > > Kindly help to export data like name and percentage from all the sheet (30 > sheets) to a new file or in a different sheet. > > E.g > > Name pro

RE: $$Excel-Macros$$ Re: Fw: Query on Text to Columns function

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lalit Mohan Pandey Sent: Thursday, August 29, 2013 2:10 PM To: excel-macros@googlegroups.com Cc: vatspoojav...@gmail.com Subject: $$Excel-Macros$$ Re: Fw: Query on Text to Columns function Try this Option E

$$Excel-Macros$$ Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new sheet

Dear Friends Kindly help to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet. E.g Name project target ,weekly %, and monthly percent% ,present, absent are there in all sheet but i want to export only Name and monthly percentage to diffe

$$Excel-Macros$$ need help to create Manpower Assigning report

Dear Friends kindly hep me to create a manpower assigning report. E.g: *Project name *:xx *Input:* *Per day target*:according to project name its should target value. *Available manpower*:manually we can enter *Manpower needed according to input*: Based on input divided by per date target how m

$$Excel-Macros$$ Re: Fw: Query on Text to Columns function

Try this Option Explicit Sub SplitValues() Dim lngLoop As Long Dim vararrRawData() As Variant Dim vararrSplitData As Variant 'Const variable change accordingly as per your requirement Const strDataRangeToSplit As String = "C1:C65536" Const s

RE: $$Excel-Macros$$ Embed Picture in particular cell

Your welcome waseem, OK.. I'll see your query Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Thursday, August 29, 2013 1:16 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Embed Picture in p

Re: $$Excel-Macros$$ Embed Picture in particular cell

thanx a lot Ravi. it is not what I am asking. But it is too good. I shall use it. On Thu, Aug 29, 2013 at 12:53 PM, Ravi Kumar wrote: > Hi waseem, > > ** ** > > ** ** > > See if this helps > > ** ** > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-mac

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

this is the default folder for saving addins if you want to save in different folder select and save..where youwant to save From: Divaker Pandey To: excel-macros@googlegroups.com; ashish koul ; NOORAIN ANSARI Sent: Wednesday, August 28, 2013 9:13 PM Subject:

Re: $$Excel-Macros$$ VBA getting data from web site

pls provide the url of sharepoint website and excel sheet where you want data From: Mithun Dhar To: excel-macros@googlegroups.com Sent: Wednesday, August 28, 2013 6:59 PM Subject: $$Excel-Macros$$ VBA getting data from web site I am trying to import data fr