$$Excel-Macros$$ Re: Formula to Count Specific Words

That worked very well. Thank-you Jeff On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote: > I've got a tracking sheet with 6 columns, each row being an entry for > equipment maintenance. Column C contains the serial number of the > equipment. On a separate > sheet

$$Excel-Macros$$ Re: Formula to Count Specific Words

When I opened the file, the formulas don't work on my PC. WIll they not work in Excel 2003 ? Thanks On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote: > I've got a tracking sheet with 6 columns, each row being an entry for > equipment maintenance. Column C contains t

$$Excel-Macros$$ Formula to Count Specific Words

I've got a tracking sheet with 6 columns, each row being an entry for equipment maintenance. Column C contains the serial number of the equipment. On a separate sheet I have a summary, by serial number, that I want to calculate the total number of times a particular entry is made on the tracking

$$Excel-Macros$$ Create report & print based on cell value

I have a list that is used to track when people are issued uniforms. I'd like to create a macro that can look at the date in the cell that indicates when they get their next set and prints out a list of all employees where that date is past the current date. My sheet has 4 columns - Employee Name/

Re: $$Excel-Macros$$ Paste to Next empty Row

   If lRec > 0 And lRec < lLastRec Then >     lRecRow = lRec + 1 >     .Range("D5").Value = historyWks.Cells(lRecRow, 3) >     .Range("D7").Value = historyWks.Cells(lRecRow, 4) >     .Range("D9").Value =

Re: $$Excel-Macros$$ Paste to Next empty Row

xlLastCell).Row > > perhaps before saving you can sort the data so you can get rid of any > empty rows that are created... > > Paul > > > > - Original Message > > From: JMac > > To: MS EXCEL AND VBA MACROS > > Sent: Tue, November 2, 2010 7:53:25 AM

Re: $$Excel-Macros$$ Paste to Next empty Row

10 rows of data. > the above line will return 10. > Now delete 5 rows. > It will STILL Return 10. > until you exit the file and re-open it. > THEN it will return 5... > > Still... > > hope this helps, > > Paul > > > > - Original Message > > F

$$Excel-Macros$$ Paste to Next empty Row

I've got a workbook in which a user inputs values into cells on sheet 1, and then the info is copied to a log sheet. I'm using the following code to find the next empty row in the log sheet to paste the info: With historyWks lastRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Row -

$$Excel-Macros$$ Auto Insert into Cell

I have a worksheet in which I'd like to auto insert the date/time into a cell in column A and the username into column B, if data is entered or changed in the same row in column C. What would be the best way to accomplish this ? Thanks Jeff -- --

$$Excel-Macros$$ Send Email from Excel to Multiple Addresses

I have a excel 2003 file that contains the following code to send a email message to several people. Sub SendMail() Dim OL As Object, MailSendItem As Object Set OL = CreateObject("Outlook.Application") Set MailSendItem = OL.CreateItem(olMailItem) With MailSendItem .Subject = "Test" .Body = "Tes

$$Excel-Macros$$ Escalation

Hi, I have a spreadsheet with a "Date Entered" column and a "Days Open" column. Every time a new record is added, the date is put in the "Date Entered" column and a formula in the "Days Open" column calculates the number of days between the date entered and when the Status is marked closed. Is it