Recent content by bfraser

thanks Hui.

=LEFT($E$5,2) =MID(E5,4,2) =RIGHT(E5,2) I'm all set. I using above formulas.

I don't think i explained my self well enough. Cell A1 contains 17/15/13 I'd like cell A2=17 A3=15 A4=13 thanks for any assistance

Looking for a little help to change a cell that contains "17/15/13" . into individual cells that contain 17 15 13 respectively

=SUM(SUMIF('February 3, 2014'!$L$2:$L$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$M$2:$M$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$N$2:$N$58,D4,'February 3, 2014'!H2:H58)))) Is there an easier/neater formula than this?

What's the best way to insert large data into a table. When I insert more than a few item into a table, the file freezes/locks up. The table has 1500 rows with two col with formulae and one with some conditional formatting. To insert the new rows of data, I have to first convert the table to...

Thanks Hui, that works. Is there a "catch" to using .xlsb? Circular Referecne- I wanted to fill the blank cells w/a date in order to be able to sort by the date instead of text. Asa, in a previous post set me straight, just enter "0" and format cells as a date. That removed the cir. ref. in...

http://speedy.sh/gntvM/PM-Tracking-Log-Final.xlsm The link is to a back up copy of a workbook I use to track preventive maintenance. The original workbook became corrupted and would not function, i.e. the macro would not run. Some background: Hui helped me out quiet a bit with the macro, the...

http://www.speedyshare.com/files/30801061/PM_Tracking_Log_Final-copy.xlsm New link. My goal is to be able to sort col E & G by date. Blanks didnt allow that. Added circurlar ref to add dummy date 1/1/00 in Col E and 12/30/00 in Col G. I can sort col G by dates but Col E gives the "Date...

yes. whole col formatted as date

Little too busy lately, but I have to revisit this. http://www.speedyshare.com/files/30495932/New_Asset_List-test.xlsm The link is a new table that has dates and ,due to the newness of the table, blanks in Col E. Data is entered into Cols E,F and G by using the userform assigned to Rect. 2...

Thanks again.

I have a workbook (Hui wrote most of the code, thanks again) w/a userform that allows the user to enter an equipment name a date and a technicians name into a table. Getting a little comfortable w/the code so I made some changes to the ws, just deleted a few cols that I didn't need and added...

You could copy and paste a link to the dates into the salary and payslip workbook. Then use an if statement to show any birthday/anniversary message.

I have a table w/ a col that contains dates. I created a pivot table and try to sort by dates but I only get "Label Filters" and "Value Filters". Why don't I see the "Date Filetrs".