manually

Hello! I made a formula to display the latest value entered in a column on a different tab. In the column on “Sheet2,” an employee enters the new amount of mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns)...

I want all cells in a worksheet to expand after every input as if you had selected them all, then double clicked the grid line to manually expand them. Thanks in advance

I've run into a curious problem. Using Data-New Query - From Oracle Database, I've created an ODBC connection to oracle (with a SQL statement). What I'd like to do is use VBA to force a refresh. My current method is using SSIS to execute a "Macro"/subroutine which works until it gets an...

I am having trouble writing a VBScript file to replicate a macro that I manually trigger at the same time each day. I have tried tweaking several examples provided but none of them quite work for my situation. My objective it o schedule a batch file in Task Scheduler to run a script which...

Hi all, I have a Google worksheet where I count the days from a manually entered date, column E. The number of days passed is then calculated into column N. E3 - Date (this is manually entered) N3 - Age (in days) using the following formula - =IF(E3="","",(Today()-E3)) L3 - Status - this is...

Greetings, Please could you let me know how I can change the following in the Properties of Excel without having to do each column manually. I always need to show as follows: R 0.00 and NOT R - Grateful for your assistance

This probably sounds very simple but I'm stumped. So in the first column I have my mileage rate which is 0.25p per mile then I my full row of values of mileage (300, 180, 120). Then the last cell of the row I want to multiply each value by my 0.25 to give me a total. I've got it to work by...

I currently run the below, which deletes every Connection in my workbook. But I only want to delete those with names starting with the text "Connection". See the image below; at the bottom of that list of all of those names are a few that I created manually named "import_file", "finance", and a...

Hi I have list of accounts and I need each account to be pasted 12 times. So I need to transform Column A into Column B. I have 1600 accounts so I was really hoping not to do this manually :))

Hi, my worksheet has a date manually entered in A1, I use the formula =EDATE(A1,6) to project the date 6 months ahead in A2. In A3 I manually enter “pass“ of “fail“. I would like the date in A2 to only be projected if A3 reads “pass“. Thank you very much.

i have this odd issue original CSV files have data in various columns ... if i rename the csv files to xls manually FIRST then open the file, i am able to delimit according to semi colon because apparently that manual rename moved all the data in column A however, if i rename the csv...

I've searched the wonderful world of Google for a simple answer and wasn't able to find one. Is there a simple way to have a standalone (manually executed) vbscript to change an Access query parameters? I have the same parameter in three queries, which is Like"XXX" I need to replace the XXX...

Long story, but will try to make the explanation brief. I work with an individual customer and provide information on a daily basis. normally we enter our info into a database and the customer imports into their own and then does what they want with the data. This particular customer (same corp...

Hi Guys, I have data in multiple rows and i want to transpose the data into one column one after the other. i have to do it right now manually and it is very time consuming. Is there any way or formula to do it quicker. The format of data i have is: the way I would like to have it is: I...

If there are more than 100 names in an excel, I would like to delete all the spaces between those names at once, is there a quicker way of doing this instead of manually going into each cell and delete the space? For Example: David Beckham --> DavidBeckham Thanks.

Dear, Every month I receive a sales sheet similar to the one attached below. To do a year to date sales sheet I manually copy the new sales sheet and paste it under the old sales sheet. Then I do a pivot table and some interactive charts I learnt recently. The challenge I am facing is...

I exported some financial data into a spread sheet that has the following in this format: Col A Col B Date $/Ton 2 14 2109 6,125.34 2 13 2019 6,345.45 etc..... The dates are important as I want them to be used on a Chart so the formatting is...

I need to run a FOR NEXT loop in a macro for a specific number of times depending upon the maximum number in a column of a worksheet. Can this be achieved to avoid me having to manually edit the VBA every time I want to run the macro?:confused:

Hi, I have a report and in that the format of the number are coming in 2 different ways. Is there a way to correct this. 1. 340.35 = this is normal format, i don't have any issue with this. 2. 28.390,26 = If you could see there is "." instead of "," and "," instead of "." and also have to...

Hello, please someone for help with this macro. I wrote it manually, but when I open Alt + F11, I get some completely different formula from what I use. What I'm trying to do is the following: in the active worksheet from cell O2 to the end (because I do not know where the end will be) I want to...