repairs

Hi I am getting an error when I open a excel sheet. Excel found unreadable content in"my sheet name" Do you want to recover the contents of this workbook" and then I get the below pop up. The pop up message what I get is "Excel was able to open the file by repairing or removing the unreadable...

Hello, I have a workbook that I am creating for Work orders for our business. There are about 6 sheets that have different templates for different repairs. IE sheet one - Heater repairs, sheet two - plumbing repairs, etc. The goal is to be able to fill out these sheets and then hit the send...

Hi, i have two formulas =INDEX(Raw!A:A,COUNTA(Raw!A:A)+ROW(Raw!A:A)-ROW(),1) and =filter(Raw!B:B,Raw!$B:$B<>"Completed (Repairs completed, Available and safe to use)") is there a way that i can combine both formulas in one? thanks Sam

Hi All, Ive got a google sheet which automatically updates once my drivers log a fault with their vehicle. The action status of the vehicle changes from available to unavailable when the repairer places the vehicle in-progress meaning they are working on it. i then use vlookups to match the...

https://imgur.com/a2wvVav I'm trying to create an equipment log to monitor our facility's equipment and their various conditions. The imgur link is what I have so far. If anyone can suggest a cleaner layout, I'd be open to it. Number of Repairs-I'd like to color code each cell in this column...

Hi! I am an excel baby and know the basics of excel. I know how to pull up VBA and add modules but not much more. I'm really good at copy/paste ;) I'm not sure if I need a formula or code, but here's what I am trying to do. I want to remove entire rows from columns A-N from worksheet "Service...

Hi, I have a workbook with a macro which generates 147+ pages. i would like to have first page, last page and rest of the pages different. my footer should give the count of rows printed till the current page. I am also breaking pages such as each page has 35 rows in it. Below is the code i...

Hi, I have a workbook with a macro which generates 147+ pages. i would like to have first page, last page and rest of the pages different. my footer should give the count of rows printed till the current page. I am also breaking pages such as each page has 35 rows in it. Below is the code i...

Not so much a question, as I wanted to document this for the greater good -- couldn't find it elsewhere anywhere. Case: I have several tables in a file acting as datasources for PowerPivot. After using it for several weeks, I got this error on opening that Excel found a problem with some...

I've been working on an excel planning tool for the past few months, it contains 6 sheets, some user forms, some modules, and loads of vba code. some times during this months excel has crashed on me due to infinite loops and computer crashes. after some crashes excel needs to repair the program...

Hi All. I have a superpowered workbook (macros galore). Occasionally, upon opening I get the 'this workbook contains unreadable content' error. Excel repairs the file and the error is always the same: "Removed Records: Sorting from /xl/worksheets/sheet10.xml part" (There is no longer a...