removed

I have a file that displays dollar amounts as such: 30 86.25 150 170.84 So it's really $30.00, $86.25, $150.00, $170.84 I have to convert those numbers so that they become as follows: 3000 8625 15000 17084 So it's not just a matter of adding a set number of following zeroes, because...

I know there have been numerous posts about this error message, but none of the fixes has applied to me. I'm exporting to Excel from an Access table, and when I open it I get an error message prompting if I want to recover as much as possible. When I do, I see: Removed Records: Named range...

Good day guys and girls I have an issue and need to find a way to resolve it there is a column that has an amount and in that field, the number has 6 spaces and cant removed with formula I have to do it manually $ 1,632.00 I try to replace, =substittute(h2," ","")...

I want to add two more layers to the formula. If the cell is deferred or has a "date deferred" I'd like the formula to return DEFERRED or else just return the "date" like it normally does or if the item has been removed it returns removed . What's actually going on is we have to perform...

I have a master list of names with assigned account numbers. (sheet 1, col. A, B respectively) once that user name is placed on list to be removed, (sheet 2) I need master list to auto update with new user name and account. If there is no new user name to input, then place the text "available or...

Good morning, group. I have hit a roadblock on a solution I am trying to come up with using PowerQuery. Every month I have a new csv file that contains the list of company id's that I will use to track if they are new, existing or removed customers. The new csv will ONLY contain those company's...

Hi team, I have list of entries in an excel column, see example below AB203467A1 SC345745BB KC983434T HE98765P1 AS456382 I want to have a macro that convert these numbers to the following and paste in the next column AB203467 (A1 removed) SC345745 (BB removed) KC983434 (T removed) HE98765...

Hi, This is a flow, (transportation, graph, etc.) problem below. Variables and their values are given in Columns A and B. Situations based on Variable 1 and Variable 2 are given at the D,E and F columns. The total flow must not be longer than 10. If so, it means overload and skip that step...

Removed Feature: Data validation from /xl/worksheets/sheet5.xml part Removed Feature: Data validation from /xl/worksheets/sheet14.xml part Removed Records: Sorting from /xl/worksheets/sheet6.xml part How can i overcome this error? Can you please provide me the solution.. Thanks, Sasi

I have removed all the Margins , Header & Footer... Thanx Brian

I want to de-clutter the list I see in my VBAProject window. I see a lot of modules that have nothing in them. Perhaps they did at one time, but I'm guessing as macros were created and removed, they became empty. ?? So if I double-click on one that shows nothing in the window, is it all right...

Hello there, Please forgive me if you believe the answer to the following is already on the site somewhere, I've been doing some frantic googling but to no avail so far. Im trying to create a tool that will take two bill of materials, an old and up to date version. The only user operation I...

I have a template file where a number of different size worksheets can be copied out to create a 'client' copy (basically everything removed other than the data in a flat file). When the flat client file is created the PrintTitlteRows range seems to be removed. I have tried to use the...

I have a dynamic dropdown list search in my excel worksheet, my problem is that the more letters i type in the search box the slower the search becomes because it recalculates for every letter put into or removed from it, is there a way to disable application.calculations if i type in a fast...

So were a tiny science company and I'm trying to help out 'sales' department girl by setting up a macro that will simplify her job a bit... She has a ton of emails and a list of customers who want to be removed from the email list. I'm trying to automate this for her.. I found some stuff out...

Hi, I have a long list of soccer teams in each cell example like the one below from a website data. B1 LIVERPOOL B2 CHELSEA B3 ARSENAL B4 MAN UNITES etc... Once a week I udate data by pressing, data, refresh all, so teams will change from week to another. I want a formula that the new...

Morning all, So moving on from the autofilter issue now resolved. My next issue is I have a data range that has several rows of data removed. Then I apply the dynamic pivot range code to refresh my pivot(s) to the new data. However, the code still keeps going to the last row where the data used...

Hi all, I'm completely new to VBA but I think I may need to use it. I'm entering data into column "P". I need the corresponding cells in column "I" to display the date and time that data is entered into "P". I found this code that has worked well: Private Sub Worksheet_Change(ByVal Target As...