instructions

Hi Everyone, I have to pull data from a site called Harvest. the data i want is employees time logs I understand this can be done and was told when we got the software that its easy but i stuck knowing where to start. I'm quite good at working things out and following instructions and was...

Morning, I have a workbook with multiple sheets. Sheet one is a list of instructions downloaded from an website. The instructions are from clients. each row represents an instruction and the orders are not all together for each client so row 2 could be an order from client A row two could be...

Hello all, I am at a loss when it comes to VBA. I have googled, but not been able to find the ideas I am looking for or to how to make it work. I am running a Mac 10.14.3 and Office 365. Here is what I am trying to accomplish: 1) I want the user to read the instructions page, then click a...

Hello Everyone. I am currently working on a project for a class, the instructions and data set are below. I know I can do this, albeit it manual, without using solver I am trying to use it. Can someone please provide some guidance if solver is the correct path forward or any other way. I...

Hello I am having challenges with sort order within a powerpivot. I am attempting to follow instructions on cascading totals, and in those instructions, is the dialog box shown below. I have researched and looked for this option in both the underlying table and corresponding data model table...

Hello I am having challenges with sort order within a powerpivot. I am attempting to follow instructions on cascading totals, and in those instructions, is the dialog box shown below. I have researched and looked for this option in both the underlying table and corresponding table within...

I started getting a message "stldole" or similar when Opening Excel, so I uninstalled and reinstalled it. It opens but doing anything with previously working workbook see Excel just vanish! I played around and finally got an error message "Could not load an object as it is not available on...

I am using the statistics functions on Excel 2016, which have various items listed as 'compatibility functions', for instance, =mode and =stdev. I wanted to know, if I import an old spreadsheet: 1) Is there somewhere I can find out which of the new functions the deprecated ones refer to? For...

Hi I need to connect to the internet through a 3g usb modem (Huawei E173) using AT commands. Is that possible?? I searched a lot but didn't find any instructions about how to do that. Thank u in advance.

Where do I find instructions for using MrExcel HTML Maker? I've searched and can only find download details. I've installed it and it appears on the menu. I highlight the range but the "Generate HTML (Specify Option)" is always grayed out. TIA Bob

Hi in the article below it is mention that VBA is used to automate tasks and repetitive instructions. I do not see any different between these 2. Can you give me an example of these 2 things. Thank you so much. Why learning Excel VBA is so important?As you become familiar with Excel, you will...

https://drive.google.com/open?id=1xR7n4f-Dt8CTH4zNGRoGl2SqtqHYD2nX Hi, Could anyone please help me do the excel and the complete set of instructions which are already mentioned in it,

Hello, i am trying to modify a formula to count partial matches, my current formula is =COUNTIFS(Allocation!H:H,'Instructions '!L3,Allocation!AB:AB,"<="&EOMONTH(TODAY(),0),Allocation!AB:AB,">"&EOMONTH(TODAY(),-1)) which works correctly , for matches in the current month. However, I am now...

I want to use a series of message boxes to describe to the user how to use a sheet in a big file that I have (I have about 20 different sheets. What I would like to do is set up a Select Case statement so that when the user pushes a button the appropriate set of instructions will pop up...

Hello, I am trying to work out the vba, to replace "pass" and "investment" with the cell location Sheet Instructions cell C26 and Sheet instructions C35 as these are drop down lists which can contain various options. I can find numerous examples where everything is contain on a single sheet...

Hello, I have been given this tool (FA-OB-Conversion-Tool-V2.0.xlsm) to convert accounting data from FreeAgent to Xero format to import into Xero. I have an iMac OS X Sierra using Office 365. The file name does not appear in the: <tbody> "2. Verify that you have opened the correct file, which...

I want to add "Microsoft Excel XX.X Object Library" to Excel. I have office 2003 so pretty sure XX.X is 11.0. But no such reference appears in the reference list. Googling for help gives this In VS, right click the references > Add Reference... > COM tab Then select "Excel 11.0 Object...

Hi, I'm sure there is a simple answer to this but I cannot find it. I have two worksheets one called"Worksheet" I enter Details of what I want someone to do on this sheet ie Wash and reproof rug,These instructions are in rows "E3:E26" The other worksheet is called "Invoice" I would like this...

Hi all! I hope to have chosen the right section of the forum, if not, I'm sorry, feel free to move my thread in the most appropriate one. I'm writing since I have some difficulties in writing the correct SQL instructions when using Microsoft Query to pull out data from an Excel table. I'm...

HI, I have been searching the internet for help, but have been unable to find any. I am looking to automate copying information from an excel worksheet into an existing sharepoint list. is this possible? if yes does any one have any instructions or links to websites that provide any...