Use VBA to Autofill a Row until the end of the number of data in another row
Hello, I need some help with the following problem: The Macro should select the first cell with the vlookup (AY2) and autofill the complete range in the column AY until the last row that contain data in the cell next to it (Column E). Column E is the cell that the vlookup refers to. The situation looks like this: The code that I have so far looks like this: Sheets(3).Select Range("AY2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-41],DennisAR!C[-50],1,0)" Selection.AutoFill Destination:=Range("AY2:AY1662") Range("AY2:AY1662").Select The problem with this is, that the number of rows with data always change every week. So I cannot use a static row number of 1662. I am looking for a way to make Destination:=Range("AY:AY1662) dynamic. In fact it has to refer to the number of rows with data in column E. Thank you very much in advance, Kai
Microsoft will release a UI modification apps built specifically for Windows 10 2004 and later
For Windows 11 users, don't like the Windows 11 style Start menu, taskbar, search menu, window switcher, task view, file manager, notification center and operation center, and they don't like the transparent tile in the Windows 10 Start menu. Microsoft decided to launch a personalized UI modification apps for Windows 11 and Windows 10. You can reproduce the Windows 10 style Start menu (Includes options to show more tiles, enable theme-aware tiles, show recently added apps, show most used apps, show suggestions occasionally in start, use start full screen, show recently opened items in jump lists on start or the taskbar and more), taskbar, search menu, context menu, snap assistant, window switcher, task view (timeline), file manager, news and interests, flyout (Includes options to Network, Sound, Clock, Battery, Language switcher and more), notification center and action center. And you can also reproduce the Windows 8.1 style Start screen (Horizontal Scroll Only), Windows 7 style Task View, classic style, right-angled window and so on.Add tab/page to group on other page
Classification: TABS PRIORITY IN MY OPINION: 5 on a scale from 1 (low) to 10 (high) At the moment, it is great that tabs can be moved to a new window, other windows in profile and other profiles. There is also an option to add tabs to groups. However, this only applies within the current window. It would be ideal to be able to move tabs to another group on a different window (but in the same profile).Edge Mobile UI refresh / customisation
I would love to see an updated mobile UI - primarily taking another look at the bottom toolbar/menu as I think the current icons aren't necessarily the best use of space. Specifically, I think the back/forward buttons probably aren't that useful for the majority of users as the same actions can normally be performed via swipe gestures, or (in the case of Android) built in navigation in the OS. These buttons could probably be relocated to the secondary flyout menu. In their place, I think it would be much more useful to have a new tab button, and most importantly a search button - which essentially gives focus to the URL bar. A lot of users frequently request placing the URL bar at the bottom to make it easier to reach, but Brave implements a search button on the bottom bar (see screenshot), and I've found this has completely removed the need for a bottom URL bar. I'm sure countless others will disagree with how I'd personally like my icons set up, which is why, like most things - I think the abilty for users to customise the UI to suit them would be best. We already have this option for the secondary menu, it would be great if the primary UI menu could be customised in the same way.
SharePoint Access Requests
Hi Reader, I'm having team site, with below settings even I configured as shown above. site owners aren't getting access requests except me(who created the site). even i tried adding the users to Site Collection admins but no luck. am i missing any configuration settings here ? how can all the site admins can receive the access requests ?SharePoint Request Access
Hi Reader, I'm having team site, with below settings even I configured as shown above. site owners aren't getting access requests except me(who created the site). even i tried adding the users to Site Collection admins but no luck. am i missing any configuration settings here ? how can all the site admins can receive the access requests ?Money in Excel - Dual accounts not allowed
New Money in Excel user. Spouse and I both have 401k accounts with the same institution. Money in Excel will not let me import both accounts. Hoping this can be a future fix. I tried to combine the accounts at the institution, but they don't allow combining 401k accountsI deleted merged cells - and all rows dissappeared - help!
I now only have row 2 and 3 (the headlines), and the area below is just grey (now row-numbering or anything, just grey void..) - how to get back the main part of my sheet? As far as I know, I havent hidden or deleted the rows, but they dissappeared when I tried to delete five columns with a shared merged cell on top of above them. Thankful for help!
