Drag to fill not working at all
My drag to fill randomly stopped working the other day. The option doesn't appear to even show up anymore even though the "Enable fill handle and cell drag and drop" option is selected in the advanced options. I did some research and someone suggested to go into the control panel, select modify Microsoft 365 and do internet repair. I did this and it did not work. I completely uninstalled and reinstalled Microsoft 365 apps and that did not work. I have tried clicking and unclicking the "enable fill handle and cell drag and drop" option and this hasn't worked either. Any other ideas?
Toggle Button Code
Hi I have the below code in a toggle button which places an ‘X’ in the active cell which could be anywhere on the spreadsheet. Private Sub ToggleButton1_Click() If ActiveCell.Value = "X" Then ActiveCell.Value = "" Else ActiveCell.Value = "X" End If End Sub Is there a change to the code I can make to force the toggle button to place/remove the ‘X’ from specifically cell ‘C3’? Many Thanks Andy
Data validation based on value in a cell
Good afternoon, If anyone could help, this would be great. I'm trying to build an Excel in which I can pick a brand in a cell based on data validation, than in another cell I would like to pick a series based on a reduced data validation. And so on with Typenummers. So ideally, I would like to pick a Merk (for this example Lekker), then pick a Serie from a drop down that only shows XL and S (for this example S), and that select a Typenummers from a drop down that only shows 753 and 159. Any advice is welcome, thanks! Reinier - The NetherlandsSwitch my License in Excel
Hello Community, I need some help with an issue I’m facing. I am currently using the second account license for my Microsoft 365 apps, but I’d like to switch back to the first account. I have tried using the “Switch License” option under the second account, but it hasn’t worked. I would appreciate any alternative steps or solutions you can suggest. Thank you.
Delete Empty Rows ONLY
I saw someone else's post, but nobody addressed the problem. Their solutions delete every row that contains a blank cell. I want to delete ONLY the rows that are COMPLETELY blank. The top rows are what I want it to resemble. The bottom several green blank rows are what I want to batch Delete.
Converting PDF to Excel 2024 on Mac (Not O365)
Hello Guys, Looking for advice on converting a PDF to Excel on my Mac. I'm using Excel 2024 and not Office 365. Most of the solutions I've come across online seem to cater to Office 365 users. I need to convert PDF content into Excel format so that I can work with the content. Does anyone have suggestions with a step by step approach how to do so. If there is any macro available or any step which doesn't involve the use of third party tool I'm fine. Appreciate your help!
Return multiple rows with matches
I am trying to compare a variable set of numbers that will be pasted in by a user with two different columns in a table and then outputting the rows that match in either column. I would like to eventually delete the duplicates this produces...but i cant even figure out the first part. I've tried combinations of V and X lookups, Index, Match and other random things to no avail. see below for an example of what I'm trying to achieve.
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I select the name of the plan from a dropdown. Column D which is "Unique ID" Column I which is "Baseline Date" Column L which is "% Complete" Sheet "Tracker" is a Table called "Table1" I am looking for code (which I will activate by a button) which will look on sheet "Tracker" column Name "Workstream / Project" and if it doesn't match "PlanName" then go to the next row. If it matches then it needs to compare from sheet "My Plan" column D with sheet "Tracker" field "Plan Unique ID". If they are the same it needs to copy sheet "My Plan" column I and L to sheet "Tracker" fields "Baseline Due Date" and "Percentage Complete %". Great if you can help
