I need to fill a row (cells A4 - J4)  if K4 is not blank. See attached sheet

**Row 15 is how I want the conditional formatting to work.

Need this to work for 2,000 rows.
FILL-IF-NOT-BLANK.xlsx

Imagine 5 people in a small company.  During their daily work they write notes in a "day book"  aka A4 Diary.   If its a an "order" then it gets punched into the computer, but other notes, quotes, call backs, comments, call notes get put in the paper book.  When someone is on holiday it becomes troublesome to hunt through the info.

The system that records orders does not have any function to take estimates/quotes and convert to orders later.  nor does it record any notes.
They do however have Office 365 Business and Business Premium (mixed).

As every solution has to now include "the cloud" which of the many Microsoft cloud "things" could be used to replace the "paper day book".

My head says just build a quick AccessDB and or use Email but that's what I'm comfortable with.   I'm trying to push my understanding of the modern offerings by Microsoft and wonder if something like Yammer would suit such a small group? (although it doesn't seem to be included in the current business subscription).

A short coming of Yammer seems to be that must send messages to at least one group, not just a single person (unless you switch to private message).  In the paper book people can score through an items, highlight with a colour marker, *** bold something , mark its as -DONE- or other status updates/doodles etc   I'm not sure if those type of "updates" would be so easy to do in the yammer world.  I'm not sure if Yammer is searchable.

Any ideas for an old dog like me or should …

PowerPoint (Mac) How to Expand/Collapse All Sections??

I have a pitch that grows and grows, now with dozens of sections. Sometime, I need them all expanded, like when I want to search on a key word. Other times, I want them closed.

Is there a menu option or keystroke that does this??

Thanks

Hello,

I am running Windows 10 with Office 2013 on two computers.  I have a customized Outlook task form.  It has an Outlook View Control (Active X control) in the form.

On computer A, it works fine.  On computer B, I get the error "Error Loading Form. Some of the needed controls may not be registered."  Computer A and computer B have identical Office and Outlook updates, so I'm not sure why I get this error on computer B.  Perhaps it's a registry setting?  I don't know a whole lot about how to manipulate registry settings, so....

Thank you for your help in advance,
Joel

Good Afternoon Experts,

I have a basic quotation excel template that I have created and I have attached for your attention.

In principal I am trying to add some functionality to the spreadsheet to make it interactive and strong proof.

On the 1st Worksheet it shows you basic the layout of the quotation...

I would like to be able to create form so that the user can enter the data in the form and it gets entered directly in the template e.g. Company Name, Address, Post Code, Reference,

The item section is next, the user can enter an description about the item but I want to able to have a button so that you add another item or items that follows each other

Item 1
Item 2
Item 3


The other two sections are called 'Special Conditions' & 'Terms & Conditions' - this block of text is standard and it needs to follow on after the items section

Therefore, these two sections are always at the end of the document.

So when the quotation has been completed - I would like a button to validate the quote...

When the button is pressed - creates a record on the second worksheet with the quotation number and other details from the quotation.

When another quotation is started it should automatically increment the quotation number by + 1

I don't know if any of this is possible but I am looking for some help

 
Template attached

Blank-template.xlsm

We have recently migrated to Office 365 E3 for one of our business units.  They have hired someone new who will be working remotely, using their personal laptop.  

I was just informed this user doesn't have an Office package on that machine and therefore can't open the files she is being sent.  I know her O365 license entitles her to install Office on up to 5 devices, so she should be covered to install on her personal machine.

The question I have is what happens when she leaves our employment?  I want to make sure the Office installation is removed as well.  I have found all sorts of documentation on deactivating an O365 account, but nothing on what happens with Office installations associated with that account.  Will disabling her account disable Office and prevent her using it on her laptop?  Do I have to remotely connect to her PC and uninstall?

Would love to hear how others are handling this.

Using C# .NET, I'm looking for a way to convert Excel documents to PDF without using paid third party tools or Office Interop assemblies (free third party tools are ok). This application needs to run on a server, so unmanaged code (i.e, Office Interop) is a big no.

Appreciate any insight about where to begin my research!

I just got a new Lenovo P71 Laptop, and installed my Microsoft Office 365.  When I went to Outlook, it's a whole new program that I've never seen before.  It seems to be cloud-based.  How can I set up my Outlook with my local PST file ... and my gmail account to download to my Inbox the way I've always done it in the past?

Thanks,

Phil

Hi All,

I am wondering if anyone can explain how to pull data into Excel, using VBA, from a webpage that has 'options' that need to be chosen.  In other words, this is not talking about a static single HTML page (if that is the correct terminology).

I am not talking about any specific webpage, rather I am talking about it in general.

To give two examples, but not wanting to only get an answer for these two:

1) Petrol Prices

This site:

http://www.pricewatch.co.nz/pricewatch.aspx

allows you to get petrol prices in the last 24 hours.

If we ignore the initial requirement to type in the capture (assume I have done that manually),  on the next page you can 'mouse over' various regions, and it shows you the summary data.  How would I tell Excel to pull in, say, 'Auckland' fuel prices?

Alternatively, or even better, as well as, how would I then have Excel enter a suburb in the box, say, 'Newmarket', and pull in that data?


If pricewatch.co.nz is too hard (I have no real idea), then is this one easier?

2)  This site:

GroceryTracker.co.nz

gives you current grocery prices from a range of different retailers around the country.

How do I get Excel VBA to pull in, say:

Region = Auckland
Product Category = Wine



I am hoping for a general answer (I only chose these two sites as they offer constantly changing data sets that are available to …

Hi,

How can I read stock prices from yahoo finance using VBA? Please point me toward some code to accomplish this.

Thanks