auto

I have a Excel spreadsheet for users to input the data and it came with all the formula for auto calculation etc. The file size is getting big. I was thinking to learn and switch to MS Access and would like know can Access able to perform the auto calculation as what Excel does?

Dim rData As RangeDim Lst As Long, LRow As Long LRow = Range("W" & Rows.Count).End(xlUp).Row Range("V18:Y" & LRow).ClearContents Set rData = Range("A18", Range("B" & Rows.Count).End(xlUp)) rData.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("W18"), Unique:=True With...

Hi I'm trying to delete 30 sheets from a spreadsheet with VBA. The spreadsheet has about 50 sheets, but I only want to delete the ones with the word "auto" at the end of the sheet name. I've written this and it has cleared the contents of those sheets. But I want to delete them without...

Hello, Is there a formula or code that can be used to auto populate certain texts with certain values? In rows 15 to 26, I am populating column B odd number cells with FROM and even number cells with TO. When users insert rows in this range, I want the FROM and TO to be auto filled instead of...

Hi all, I've done some searching on different forums and can't seem to achieve my objective, I'm also totally new to VBA. I would like certain rows in a column that are "0" to auto hide, but when the cells receive new data and become a value I want the row to auto unhide. The cells in the...

I'm fairly new to VBS, but have done lots of work in C, and C++. I'm having a hard time figuring out if what I want to do is even possible. Basically I have a lit of equipment that needs servicing each with a unique ID. The equipment can be broken down into two main categories. Each of these...

Hi, I hope someone can help me here. I would like to set a auto contract number. I want to check the CO number if it is duplicate and then add the -n to the contract no. If it is not a duplicate it must be the next sequence in the numbering. Below is an example of what I would like to achieve. I...

Hey guys always such great help :) Had a question that i could not find on the web: I have a table with the auto fill function on which is great, however this is just one column that i would like to disable the auto fill function. Is there a way to do this?

Hi. I am making a chart with multiple data series. One of them is a fake series that I use to shade so the values are way higher than the normal series I use and excel accounts for that when auto scaling. Is there anyway in VBA where I can specify which data series to base the auto scale? Thanks.

Hi All, I normally would not come here, but sadly am now at the deadline and running this as it is does not work. I am trying to get this to auto run on open or just click the Get Report button once to run all three reports f possible. [Private Sub CboReportName_Change() End Sub Private Sub...

Im trying to create a Spreadsheet Template that strips all encoding off of pasted information. Users will copy text and numbers from Web Pages into the Spreadsheet. It will not be feasable to train them on how to ensure they're copying plain text only, as simple as that should be. Microsoft...

I'm using Power Query to pull data from 3 different tables within the same workbook. Once that data is collected, I'm putting it in a master list. This master list table has additional columns of data that can only be added after the master list is compiled, and these additional columns are...

If I have a list of job titles [JBTBL], and a list of contract years [POPTBL]; I need to copy the list of job titles for as many times as I have years, lets call this the DetailTable. Then if I change/delete/add a job title from the job title table or add or delete a contract year from the...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA code for Auto Filtering System. How Can I do it. Thanks in advanced.

I have an excel document that auto calculates multiple due dates, I’ve also built in conditional formatting that highlights due dates for “this week” (high red) and “next week” (highlight yellow) when I open it. Excel auto starts the day of the week as Sunday. Is there any way to change the...

Is there a way of changing the GMC range automatically for the formula below? =DMIN('CEA - ALL'!$A$1:$O$1172,15,GMC!A1:A2) When this is copied to the row below it updates to A2:A3 but I want it to change to A3:A4, A5:A6 etc Is this possible?

Hi newbie to VBA here, I am trying to create a macro that takes a formula created in Cell G3 drags it to M3, and then auto fills to the bottom of the last row. The way I was working on it was previously recording and making some adjustments, I cannot find a way to have it auto fill to the last...

Hi peeps. Can i ask for your assistance again. i need a formula for sheet 2 to extract info from sheet 1. In sheet 1 of my workbook i have a annual leave planner. Dates run from column f5 to nf5. Several rows below are the stats running from f20 to nf20. If the stat is higher than 3...

Pls can someone pls help with a vba macro to enable send me auto remainder from excel to gmail of my boss

Hi, I currently have graphs which compare last years figures to this years figures. However I report on these monthly and do not want to show what the figures are from last year for future months, I only want to compare form beginning of the year until now. I have all the data from last year in...