directly

Does anyone know of a way to import excel files directly from a SharePoint into access

I have recently been experiencing something I have not seen in my fifteen years of working with Excel: @ signs are appearing in my workbooks formulas directly after the = sign. For example...

Hi Guys I have a cell range H4 - AT4, I have a formula that places a specific value in a cell within the range based on a value above, example - Formula places the number 5000 in cell Z4 using the value in cell Z3. That part works fine, now what I want to do is search the range H4-AT4, find the...

I have a cell in a worksheet which is linked to a cell in another workbook. In theory the link should update when I open the first workshheet, however the linking formula has changed itself to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link...

Hi guy ! How can i go directly to a window of an application with it'ID , because it does not have Please

Hi everyone! I have 2 sheets (see below). If I click on any number in my sheet1 first column, I'd like to be able to directly jump/go to the corresponding same number in my sheet2 (and vice-versa - toggle). Example: If I click on #3 in sheet1 (row4), then Excel directly goes to/position...

Hi all, i received a excel file, in that some column are locked, means not to enter specific column like C1 to E1 even cursor is out of these column c1 to e1. when you try to cursor goes to c1 then it will goto directly f1. can anybody tell me how is this?

Hi All, We have a excel file which has pivot tables, those pivot tables are connected with database connections directly. so when we Refresh All all pivot tables are refreshing with latest data from Database directly. Now we want to change the source of PivotTable from that Database connection...

<tbody> <tbody> Hello, I have been puzzling over this for quite some time and have googled as many possible things that I can think of to try and resolve this! I am wondering if there is a way to print your file as a PDF and directly onto letterhead, in a similar way to as if you had...

The shortcoming of drop down list in DATA > validation - is that you can not add new item directly into the cell with the drop down button. The only way to do this is to bring out the drop down list and make the necessary editing. It would be nice if we can just input directly into the cell new...

Hello Guys Has anybody found a way to connect directly to Magento databases to extract data on a read-only connection basis? I have seen some $600 rip off pieces of software but I am sure there must be a direct connection excel can connect. I have searched on here and Google with no luck.

Hi there I am trying so sum all values in column B where the account in column A is either 10000 or 20000. I manage to do this easily with the following formula: =SUM(SUMIFS($B$2:$B$12,$A$2:$A$12,{10000;20000})) to get to the correct answer of 219,910,716. I am, however trying to reference...

Hi I have a list of numbers in column A & B on sheet 2. When I enter one of those numbers that are in column A into column AD on sheet 1 I would like the number next to it in column B on sheet 2 put in the cell directly above please. Thanks.

Hi, I have the following formula which works fine (refers to pic below) =COUNTIFS(INDEX(B4:H25,0,MATCH(J8,B3:H3,0)),K8,INDEX(B4:H25,0,MATCH(J9,B3:H3,0)),K9) In its current format the formula reads cells K8 & K9 as fixed values but I want to be able to use > >= < etc. on these values. The best...

We have one column of information which is 500 lines long. We need a formula to find a specific text we are searching for and then once that text has been found we need to get the cell directly below that which contains a value we need. Any help would be greatly appreciated as we've been stuck...

Picture a three column Pivot Table (Call Type, Date, and Calls Received). Right next to it I have a Data Table directly referencing the Pivot Table, an exact copy. Is there a way to make the Data Table autosize for when the pivot adds rows to the bottom? I am using the Data Table to add to a...

How do I get this to work (I know it's wrong but it makes sense in MY head): {=SUMIF(A4:D4,A3:D3<>0)*1000} I want the range A4:D4 only to be summed where the cells directly above are <> 0. So if A3 = 1 B3 = 2 C3 = 0 D3 = 0 And A4 = 300 B4 = 500 C4 = 700 D4 = 200 then the result will be 800...

I want to display a column of numbers with " representing inches. I cannot type this into the cell directly as excel will not recognize them as numbers for my formula that I need. How would I go about this? Thanks for any help in advance!

Hey guys, I am search a large array with multiple columns B2:AC46. I want to be able to use a set of accounts in a kx1 column vector on my sheet as the reference and always return whatever value is directly next to that reference anywhere within the other array (e.g. I may have 40 in column 5...

Hi I have a simple question, why in the following line the variable is not assigned the value directly like this: source_date = b8 instead of the following: source_date = Range("b8").Value Thanks for your help.