office

I need a VBA script the will allow me to look down a column and find a specific name then "Offset" to the left of that cell and change the value of the "Offset" cell. I have tried several scripts but no luck. :eeek: I have just started to learn VBA and it is killing me. I will not give up or...

On my home p.c. I have MS Office 2010 but at work we have MS Office 2013. So at home I created a Userform and the code works. However, when I send it to my work email through Outlook 2010, when I open it up at work the first thing I noticed, it's a read only file. So in Excel 2010 I clicked...

I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...

This is causing huge problems in my office and I've tried to find a solution to no avail - so here I am... We are using office 365 with auto-save off for our check register in Excel, when I am in the file and someone else opens it Excel wants me to save a copy or discard changes. I remember...

How can I tell -- by talking to someone over the phone -- if they have a local install of Excel? I've sent 2 people a macro file and the macros don't work. I believe they're using the online version, but I don't know REALLY how to tell (save a copy seems to be one way?). And then, I helped one...

Hi, I have the following time and date stamp for my staffs from the attendance system which captures every time the staffs enter or exit the office: <!-- Please do not remove this header --> <!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) --> <table...

I've tried re-installing the Connecting to HANA via Office Excel Add-in : Analysis -- but the Add-in isn't showing up on my Add-ins under Options in Excel. Anybody use the Analysis Add-in in Excel for SAP HANA and know any trouble shooting?

hello i am using excel (office 365) and i have a order entry system where i collect details from the user via user forms. this system is used on 2 PCs here in the office both running the same version of office 365 but on the 1 PC everything works perfect but on the other some of my option...

I used powerview in excel 2013 and excel 2016, but I dicided to upgrade to office 365 rather than office 2019. Has Microsoft dumed down office 365 and remove power view? To installe office 365 I had to remove office 2016. Is there a way to ***** about this. Richard

Here is the formula: =AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days I tried =IFERROR(AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days],"") it will not calculate.

Hello there, Since I installed office 2019 Excel I got data conversion problem when opening a CSV file. problem : when opening a genuine csv file form bank or postal account some lines show data on conol B or C So if a run data conversion I got a message telling that this action will...

Hello, What Microsoft Office version has the UNIQUE function present? Because I have the latest version of Excel 2016 an that function is not preset, why ? Thank you.

Hi there guys, I have an Excel file with Power Query data which I made in Windows Parallels (I have a Mac). I understand that Power Query isn't available in Mac Office yet but I thought that at least it could be visualized on my Mac but whenever I have tried to open the file it just crash...

How do I filter rows in Office 2010? Thank you.

Greetings all, I have an issue with Excel in Office 365. My company just upgraded from Excel 2013 to Office 365 (Excel 2016). Now I am having issues with macros. My form has an email function built in that is ran by clicking on a button. The email is sent to a different organization when...

OK. It appears no one is going to respond to my plea for help with creating dynamic charts from dynamic name ranges using the offset function. After repeated tries over too long a period of time to even talk about, I am finally giving up on creating dynamic charts in windows 10 and office 365...

Hi, I am having issues performing my repetitive tasks using macros. I am new to it and would appreciate some help. I recorded a macro but when I try to run it, it starts working on the source file where I had recorded the steps rather than working on the target file. Also it keeps giving...

Hi, I have a fairly standard table containing columns with office names, addresses, site codes, server numbers and contact names for each site. I want to be able to have a search box that I can type a word into and have matching results returned. I can do this using formula to search one column...

Hi I have excel at work and we use the office 365. Is it possible for me to sign up to be an office insider does anybody know because I can't work out what I need to do and if it is even possible? Cheers Joe

Probably best give some background to this call first. We use a product in school called SIMS database to record pupil/staff/contact data - the reporting tool outputs to MS Office (Word/Excel), text (plain & CSV format) among others. We have been using Office 2010 for some time but Office 2016...