manually

Good morning, I'm using the below formula to display the oldest date in a range (to the end of the month) if there is a % value in a designated cell range. =EOMONTH(MAXIFS('FA Afford'!I22:I33,'FA Afford'!E22:E33,">0"),0) In an older version of the document I'm using (where the cell ranges...

The table below shows an ID reference and each -3 (shown in red in my example only) is an accumulative count of the duration and needs to be added to the value above it. So if the ID is NOT - 3 it will be just be the adjacent duration value. However, if the ID is -3 it now has to be added to...

<tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...

Here's the link to a sample spreadsheet I made: https://drive.google.com/open?id=1cQJvncI9xsAsrTicUA4Ql-MnZI2pwW_d Essentially, I want the macro to go to the "Final" tab -filter for each unique security ID -insert a new sheet and name it that security ID -and copy and paste that info into...

Hello everybody. I'm a newbie about automating external application via sendkeys method. Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens. Maybe somebody...

I'm using the Subtotal function, and that works good for what I'm doing, however, I don't need all the extra rows. Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows. Example Row 1: route 1 item D4 order 50 Row 2: route 1 item D4 order...

Hi I am not familiar with VBA and hope that somebody can assist. SheetA: A1 B1 C1 101 98 If I manually highlight cell A1 at C1 = vlookup(A1,SheetB!,2... If I manually highlight cell B1,at C1 = vlookup(B1,SheetC!,2... (Highlight A1, refer sheetB, highlight B1 refer SheetC)...

Hello, Having an issue, currently using Excel 2016, formula's only work when I overwrite a concatenated formula by manually updating those fields with the exact same data that was being auto populated. I am using this as a small database, for 800 numbers, concatenating the base 800 numbers...

I have two date columns B and C both formatted to date xx/xx/xx I want to be able to (ideally) run a macro which searches for a specific date in column B and replaces it with a new one but only if column C is empty. As the dates that will change further down the line will be manually updated...

i need to re-arrange the tabs so that it saves the PDF in that order....is there way to do this without manually moving the worksheets? i tried re-arranging the sheet names in the vba array code, but that didnt seem to do the trickl

I need help setting up a macro for a billing form I use for work. I need when I click a button, it recreates a copy of that same excel sheet, but I need the numbers from a certain column(sheet 2; column e13:E21) to slide over a column(to D13:D21) and also be added to the value thats in that...

Hi, I'm trying to make myself a cleaner coder, and hopefully write code that does not slow down every time I run it. Can anyone help me with a list of variable types that need to be set to nothing or unloaded from memory manually at the end of a macro? Thank you, Daniel

Dear Sir and Madam, Need your suggestion on how to shorten this formula ? The data range is from B11 to B21, at the moment I had to manually add in one by one...

Hi guys!!!! I have this data of weight meassurements, i have one measurement for every hour of the last 5 years, but the format of the table its not useful for me, I need to change it to another format. The one in green is the one i have, the one in yellow is the one I need. <tbody> I used...

Hi all, I have an excel sheet that has a dropdown with different selections (Products) in it and based on that selection a certain cell generates a preset number from a table. I have then another cell before that where I can enter a number manually. finally I have a cell with a formula in it...

I always have to do it manually and honestly it sucks, Thanks you guys

Hi all, again... I have been reading on this and have found a few good youtube videos. One in particular mentioned 4 ways this could be achieved, the best way being the new function SORT. Sadly, this is not available on my newly bought office 2019 professional. Just another way Microsoft has...

I'm trying to modify an existing macro that interacts with Host Explorer to essentially reset a connection prior to executing the remainder of the macro. Manually, I would do this action by pressing, in sequence individually, "ALT - F - D - ALT - F - T" as these are the keystrokes/hotkeys to...

How do I write code so that my macro selects all used rows? For example, I have to import data into an Excel workbook every morning and the number of rows are never the same. I need to select all used rows (I do this by manually with ctrl + shift + down arrow) and adjust the row height to...

Could someone please help me to create a small VBA script that is able to automatically sort the 10 rows contained within range A1:C10 in ascending alphabetical order, using the contents of cells A1:A10? Also, if I record a macro while manually performing the above sort just using the Sort...