site

Hello All, I've received some amazing assistance with a few complicated (to me) Excel issues on this site so I figured I'd try on this latest problem. I've received some criteria that I need to use to write some fairly complex IF statements in order to populate fields in Excel. I've provided a...

Hello all, I currently have a macro in Excel that automatically writes the file to various places after working its magic, including a shared drive and also to a Sharepoint site. No issues with writing the file as long as we're connected to the network. We are moving to a new Sharepoint site...

I want to build a file that utilises an Access database but the file needs to be stored on a SharePoint site. Microsoft have informed me that using an Excel front-end to query an Access database doesn't work and I'm wondering if anyone has managed to get a front end Excel file to work with a...

Hi folks, This macro works when testing, but does not work when running as part of a sequence. It is supposed to exit the sub if a site (country) does not exist, and there is one known site name that does not exist in the pivot table. If a site does exist, then it is supposed to copy the...

Hi, Import table is not working for this site. http://www.oddsportal.com/cricket/north-central-america/caribbean-premier-league/results/ =importhtml("http://www.oddsportal.com/cricket/north-central-america/caribbean-premier-league/results/", "table", 2) I tried all table numbers.

Hello Excel Gurus, I need your help, please. I am trying to create a time plan in Excel. I got two columns, one says "Start", the other "End". I'd like to have these two cells automatically filled out when a first non-empty cell is detected in an array - i want it to pick up or "echo" the value...

Ladies and Gentlemen, I have just taken 2 excel courses and I was unable to figure out how to do this based on the knowledge I received. I work for a construction company and I am trying to make life easier for us all. I have a table with 3 columns. Column 1 - "Due Date" (This is the date in...

<tbody> Site Product UOM Product ID ID Value Sale Counter Results A Pen 9 26525802 77587241 1 2 1 A Pencil 9 <tbody> 32266576 </tbody> <tbody> 77586563 </tbody> 2 3 2 A Pen 9 47163111 77595902 3 4 A Sharpie 9 49726635 77592873 1 8 3 B Pen 9 26525802 77583416 8 9 1 B...

I have an Excel sheet which contains the following parameters: 1. Country 2.State 3.Site 4. Shifts 5.Experience I have another sheet in which I have the following 1. Country 2. State 3. Site 4. Vertical I want a seperate Excel Sheet which contains the following columns: 1. Country 2. State 3...

Morning all, I have a long list of the example data below and would like to bring back the top 5 site names (based on highest number in "kWh" descending) where the manager is "Graham" and open / Closed is "Open". Any help would be appreciated: <tbody> Name Manager Open / Closed kWh Site...

Hyperlink Problem says [The address of this site is not valid. Check the address and try again] Please help. Some are ok while few did not work at all. I got pop message says "The address of this site is not valid. Check the address and try again"

RE: Sorting + adding new data issue between sheets Hi I have a spreadsheet containing several sheets, one is called "OTR Sites Dashboard" and It has the following columns: - Country Site Name Site Adddress Site Proposed Go Live This feeds all the other sheets ='OTR Sites Dashboard'!E16 for...

Sample data : <tbody> Site Id Invoice PO Region Amount Quantity Discription Sheet 1 Sheet 2 99 A23 B22 C 1993 3 cable cables </tbody> there will be lots of data like this. What i want is to be able to use VBA or excel in a new sheet which will take following criterias : sheet name from...

Hi, I just recently purchased called " Power Excel with Mr Excel" (edition 2017). On the back of the book, I am referred to a site "https://www.mrexcel.cl/2017/powerfiles"...th site in question doesn't seem to exist ? Can you assist me ? Thanks

Hi, looking for some help - I am at a basic level at excel, have to use the formula wizards for vlookups and generally use google to find an answer and use trial and error to find a solution. To this question though, cant find anything, We run a team of engineers that work over several projects...

Not sure if you need this but here is my info: computer: custom build - Processor Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz, 2808 Mhz, 6 Core(s), 6 Logical Processor(s); Memory - 16GB DDR4-3000; Video - Radeon RX480 8GB; Storage - Intel 600p Series 1TB M.s-2280 SSD and 500GB SSD 2.5"; OS - MS...

Hi, I have a table called "SITES" like this: Company Site freelensia www.freelensia.com google www.google.com mrexcel mrexcel.com The table is then loaded into Power Query and displayed as table SITE2 In table SITE2, I have added a new column with hard-coded text like this: Company...

column A -Code ABC ABC ABD ABD ABD Column B-Acct # 123456 234567 567890 Column C= Biz Site A0000001234 A0000001234 A0000002345 i want to do a formula, that tells me how many accts per biz site for for example in the above A000001234 would have 2 accts for that biz site i want it to be so...

I have 2 tables that I am trying to figure out a less painful way of merging into a single table or identifying some other method to link the 2 tables. I currently have 2 tables that report on supplier information. Table 1 shows by supplier what category or categories that supplier supports...

Hi can you show me how you construct financial model I havent got a clue :( <colgroup><col><col><col></colgroup><tbody> Modelling Skills We have 12 new sites coming on over the next 34 months (starting Feb 18 and finishing in Dec 20). We need to create a model to calculate our...