original

I'm not sure why this is happening, and you guys helped me with this original code... but whenever I run this macro, it is ALWAYS trying to filter the first column when the any cell left of AS1 is selected. I have done some modifications to the original, but can't figure out why it's doing it...

Hi We have originally added fees to accounts based on a percentage of the original balance. We have a new client who wants their fees capped to specific amounts. I've done the formula for the new cliwnt but I'm struggling to add the equation to the original equation. The data looks like this...

Book1ABCDEFGH2A is the original number as written.3484535831 / 2 (2) this can be broken down to read 84535831 and 84535832. (2) means 2 people56column B, removed the / and replaced the last number with what was after the /.7C,D,E if more than one / exists. No more than 4 should be there.89Column...

Hi everyone, I have a formula that populates Y or N based on a few criteria (also has conditional formatting that shows Y as Green and N as Red). The formula is working fine for that purpose however, when there is an error the cell populates #N/A (this is fine) but I would like the cell to be...

Hi guys, Got a question about vlookup with columns functions. I use, VLOOKUP($B16,$B$4:$D$13,COLUMNS($B:B)+1,0) and I paste the formula across cells C16 and D16 to return matches of author and price. But when I use B$16 instead of $B16 in the formula, it returns a match in author but not price...

Is it possible that when i save a workbook, a macro would look at a cell and save it as what is ever in that cell and partially keep the original name? Current file name: Applications_Form What i am looking for the macro to do is; look at K1 (123456) and add it to the original file name so...

As you can see in the image, as I import some document into the excel spreadsheet it will be name "xxxx" I would like to automate the process where it will automatically change the spreadsheet name. If document row is from Row 'A' to Row 'H'change spreadsheet name to "Tester Utilization" else...

original sheet copied and pasted to a new sheet I just created...i deleted the old, original sheet and magically rhe file size reduce by 2 MB. it's not due to formatting cause the original sheet dint have any formatting (i did a select all, clear formats just in case).... just trying to know...

Hi, I have been fiddling with this logic, but I can't seem to make it work. Basically I just want to transpose arrays with varying lengths using the Ubound property. Here is the original code: Set rng = Range("VBAOutput") rng.offset(0, 229).Value = Application.Transpose(array) THANKS

After running the macro, I want to save a new copied workbook with a filename using several cells in the worksheet + date. This file will be used by multiple people so the path will be different by user. I was hoping to rename the workbook and when saved, it would be in the same folder as the...

I have Office 365 ProPlus (Excel 2016) and when I use to create a pivot table from my power query connection only data it automatically creates a duplicate query and the pivot table uses that as its source query, rather than the original source query. Why is this doing that? If I make any...

Hello everyone, I have a lot going on it my workbook for work. The sheet has had a lot of modifications to it and it is now behaving slowly. It takes roughly 6 seconds to apply a filter to the worksheet when it used to take .01 seconds. If I move the worksheet into a new book the speed is right...

Hi, I have an excel table with 20000 lines. Here is a short sample it, with license plate number (column B) which last process phase they have gone through. There are some duplicate values in the plate numbers, which have been indicated in column C. In column D, I would like to return for each...

I'm going to preface this with I essentially have Frankenstein'd some code together from googling since my VBA skills are very low. Here's what I'm trying to do: I want to go through multiple workbooks (saved in different locations), search a certain column for the word "fail", if it's there I...

Hi, I just got excel 2016, and notice the difference in movement when a cell is highlighted. How do I change this back to the original? Just curious are there any major differences I should notice? Thanks!

Dear Friends need help for VB code I am sending above referred file containing 500 plus records to almost 50 persons weekly for updating comments in column G and I (hatched in yellow) against each Job no (refereed Column A ) for they are responsible. I am sending file through mail to all 50...

Hello I am needing some help or ideas of how to easily transform original data into a simplified list, ideally just a pivot, but because my original data has tons of columns and due to the circumstances.. I am giving up hope that there is not an easier way to do this.. Background: 1. It is...

Hi, I'm importing date from CSV file including date into excel. The date field in the CSV file is configured as "mm-dd-yy hh:mm:ss". The date cells in the excel sheet is configured as dd-mmm-yy hh:mm:ss. My problems is that the date imported will show correctly if the day is below 13 but...

Hello Everyone, I'm looking for some help. Before going in the details, I would like to clarify that I am a novice at VBA. I'm trying to do the following: I have a couple of tables that are updated everyday. I have a query built out of power query that consolidates these to tables into a...

I'm trying to create a second table from an original table based off of non zero values indicated in the third column of the original table. I need to do this using vba / macro, here is a visual of what I need to do. the range of the table is cells G10 to I47, this is just a snippet. I was...