## Discussions Showcase Albums Media Media Comments Tags

1-9 of 9 Results
1. ### Google Sheets - clear cells but keep checkboxes

Business Applications
Hello all- I'm new to Google Sheets, and need to use it for this spreadsheet I'm working on. In column 'A' I would like checkmark boxes (tick boxes). But the content of rest of the rows I need to clear occasionally. Is there a way so I can select an entire row and 'clear row', but have the...
2. ### Pictures in Excel

Business Applications
Hi I'm using Office 2019 on a Windows 10 64bit PC. Is there a way to insert a picture into a cell in Excel, please? I know I can insert a picture into a spreadsheet but I want it to be within the cell so the the cells to the right can relate to it - for example, if I was inserting a picture...
3. ### Solved SUMIFS help

Business Applications
I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2). How...
4. ### Emailing from Excel

Business Applications
hi guys ive scoured the net and this is as close to the answer i need hope you guys can help. I am looking to have excel filled out with the following: name.......start date..........due date but then somehow vba this to email outlook say 2 days prior to the due date to remind staff to complete...
5. ### Solved IF Statement

Business Applications
Hi there, I can't figure out how to properly write an IF statement for this specific scenario. I have to calculate E.I (Employment Insurance). E.I is 1.27% of your gross income. If my annual gross income is for example \$66'000 I'd type in the formula =(C7*1.27)/100 (C7 is the cell with...
6. ### Simple interactive Excel spreadsheet

Business Applications
I'm trying to create a simple interactive spreadsheet for a club that I run in a local school. We sell food at this club and, because children inevitably lose money throughout the day, their parents have sent us funds in advance. We are therefore looking at the simplest way of keeping track of...
7. ### Spreadsheet Help

Business Applications
Heyo people! I need to start printing and cutting out 6,000 squares, STARTING TOMORROW. Before I do anything though, I need to have the template ready -- and I don't. I have done it on paper and know that I need .25" margins, 12 2.25" squares per page, and an extra slip that is 1.25". When I try...
8. ### Linking a form to database in excel

Business Applications
HI guys, I need to create a form in excel which, after the fields were filled out and submitted, the data would update a dynamically linked Excel database file. For example, my form might have three fields: Name, product and quantity. My Excel file would also have three columns titled name...
9. ### Solved Excel automatic mail

Business Applications
hi everyone, this is my first post on techguy. I really need help with a Microsoft Excel spreadsheet. The workbook consists of gauge numbers and their calibration due dates. Can someone please help me so that Microsoft Excel automatically sends a mail to a particular email address when the due...
1-9 of 9 Results