home

I'd like to use a Home button image on a button in a spreadsheet (Office 2010). I think I can do it using the FileName operand of the OLEObjects.Add method, but I'm struggling to find an example of how to do so. I had originally mis-remembered that there was an image of a house in the...

I have a multi sheet workbook with macros that are triggered by clicking on different cells. The macros perform the same function on each of the sheets but I want to place the focus on the home cell when the macro finishes running. My issue is the home cell, which I'm referring to as the first...

Over the years I have developed a really nice QAT that makes my work so much faster. I know that QATs can be moved around and so I'd like to use my work QAT at home. However, I'm finding that any button attached to a macro also carries with it its path. When I go to use that button at home I...

HI - I want to create a column with concatenated column 3 like below. Basically select values from column 1 and column 2 where column 2 value is non zero. Can anyone please help ? Highly appreciated. <tbody> Column1 Column2 Column3 Apple 10 10 Apple, 8 Car, 2 Home Mango 0 Car 8...

So I have two excel versions one at home and one at work. Both are excel 2016 but the one at work is blocked for updates. The bug I'm getting is on the most up-to-date version at home. Excel at work doesn't seem to have this bug. And here's the code: .Add Type:=xlValidateList...

Hello. I have on the 1st sheet the entire results of the Premier league 2018-2019 fixtures. They are set up as a table, from column A to D. Column A = Home team Column B = Home team score Column C = Away team score Column D = Away team This table has the purpose to be dynamic, as i...

I have the following sub which copies and pastes a range of data which has been input by user on one sheet (Input) and appends it on (All Scores), which is a master sheet of a thousand or so players and a weekly score over a forty week season. The probelm is with zeros. I have set the workbook...

I have a table and as new rows get added, I need some vba code to enter a 1 into the column AB on the new row. Can someone help me with the syntax please? The table is located on a sheet called "home" and is called tblCosting. There are things below the table, so you can't use the xlup method of...

Hello, I have a string of text in a cell that I need to separate into multiple cells, Text to Columns will work however I need a formula to do this as I don't want to have to break this out every time I refresh the data. I don't think LEFT, RIGHT, or MID functions will work since the number...

I know I used to do this in excel all the time but I can't remember how to get there. I have a column (A) with Names. Column (B) has a list of the items associated with the person in column A but the Name is only in the first line. I want to quickly fill in the rows beneath. My actual...

I have some pretty cool code set up that will automatically run when a workbook opens depending on the file name. I want to be able to compare each word of each name in two different workbooks and if any of the words in the name match, do something. EX1: Workbook one is named, "FL HOME MARKET...

I assume this is a very easy thing to do and I am just missing what I want for some reason. I am using PowerQuery and Excel 2016 (Office 365) I have 5 columns of data that look like below Location Usage Date BMD IMD PMD Home January 50 100 100 Home February 75...

I have an address list with the following fields: Name (includes: First Name, Last Name) Home Address (includes: address, street name) Home City Home State Home County Home Postal Code Home Phone Cell Work Address Work City Work State Work County Work Postal Code Work Phone I need to export...

Dear All I am trying to copy data from all sheets in one workbook but NOT copy from the HOME sheet and the Prog_Dep sheet, here is my code it copies but also copies these two sheets that I do not want it too. Sub CombineData() Dim ws As Worksheet For Each ws In Worksheets If ws.Name <>...

Hi there, I have the below bit of code. In my head, it should loop through columns 1 to 52 of row 8 of the spreadsheet assigned to cTeam, and return True if the value is like "tel". The values in those cells are Contact Tel. Contact Tel. 2 Home Tel. Home Tel. 2 etc., but the Like operator...

Hi everyone, (New here so go easy on me please). I need to create a fixture list (home and away) that can adjust to different number of players but there's one difficult part: we need everyone to have as many home games (or away games) in a row if possible and all teams must play at the same...

Hi Everyone I have a sheet and in the VBA it shows as Sheet3 (Home) how do I select this by the name Sheet3 not Home its not the 3rd sheet and could be moved or renamed so this seams the best way. Thanks Tony

I am trying to use this formula; =SUMIFS('Income by Home'!D4:O27,'Income by Home'!B4:B27,'P&L'!$B$2) Where; D4:O27 is financial data by month B4:B27 is a list of Home names B2 is a dropdown of the Home names I can see that D:O is the issue as D:D returns the first column Value - but I want...

Is there a way to edit cell M2 on Sheet1 where it updates on Sheet2 as well, but if I edit it on Sheet2 it updates it on Sheet1 WITHOUT grouping or selecting the tabs? Can I somehow specify that a certain cell is live and active through all sheets? I currently have an equation on all sheets...

Hi, I have a table below: <colgroup><col style="mso-width-source:userset;mso-width-alt:6363;width:131pt" width="174"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody> team Matches Pld...