existing

This is one of those ageless problems that I assume somebody must have been able to solve, but Google fails me. We pull data from a Master Query using Pivot Tables. Its an excellent tool in that users can not only view the standard reports but make their own. The problem is that the column...

Hi, I am using the VBA code below to export to PDF, and saving as the sheet name. Unfortunately, when I come across the same sheet name (from a different workbook) it overwrites the existing PDF. I would ideally like to append to the existing PDF instead of overwriting. If that is not possible...

Hi Everyone, I have a sheet with loads of areas all created by someone else who did not see the importance of merging cells, So I have boarders that I cant simply change the colour of as it takes ages. I need a macro that can change all existing boarders either on active sheet or in a...

I have an Access macro which basically opens an Excel spreadsheet and then copies a range of data from that spreadsheet. I want to then import that range of data into an already existing Access table overwriting the info already there. There are just a couple of caveats...1) In the existing...

What I need, is a macro that can look in Column D and add “/” and “R” to the existing 7 character text string. Cell (2D) has what the end result should be for all cells in column D, once the macro runs. <tbody> Dealer Description Matched 235/65R16 2757018 2256016...

Hi I was wondering if I can get some help, we have received a load of data in folders based on cases, we know from each case via a lookup which case belongs to which individual. <colgroup><col><col></colgroup><tbody> Existing Folder New Folder h:\ESCC\OB\KYB\3923 H:\ESCC\Donna Waddington...

Hi All, I need your expertise. I have an existing formula (that I did not create) and I want to add in the statement that if cell C6 contains "One Off" that I want the formula to return blank. Can anyone help me out and incorporate this statement into the below formula? Thanks in advance...

Hi Guys, really no idea about VBA code but I trying to learn. I have a database which I am trying to set up to replace a number of existing excel documents. I do however need the database to transfer a query to an existing excel template. So for example the database is called "test". The query...

How can I auto fit images in existing cells in a Column ?

Hi, I want to select the next row after the last existing row. For example I have existing data with 2000 row. what I want to do is to select the row number 2001. However, I don't want to use Range A:2001. Is there any way to do it using macro excel?

Hi guys I have a macro that pulls a file name and file path from cell within a sheet. The macro works well and when there is an existing file in the directory (with the same name) a dialog box pops up asking if I want to overwrite an existing file. If I select yes the macro works as...

Using existing list of classes, which are named in the format: 8A/Cp or 13W/Ma. I can print dynamic class lists for our teachers My existing code works well for printing, but because of the "/" (which we can't change) I can't PDF the files. The existing code I use is a simple print and repeat...

Hi all! I'm trying to pull data from a range if multiple criteria are met. I have done this with SUMIFS in the following formula: =SUM(SUMIFS('[PRODUCTION - 2017.xlsx]Data-17'!$RD:$RD,'[PRODUCTION - 2017.xlsx]Data-17'!$D:$D,N6,'[PRODUCTION - 2017.xlsx]Data-17'!$I:$I,{10,11,12,""},'[PRODUCTION -...

<tbody> Range of Values New Existing 1 to 10 10% 8% 10 to 50 3% 2.5% 50 to 100 .8% .4% </tbody> <tbody> Type Value Percentage to Return (from the New/Existing columns above) New 40 ??? -What formula to use??? Existing 40 ??? -What formula to use??? New 60 ??? -What...

I know keyboard shortcuts can be set when recording a macro. Is is possible to insert one into an existing macro? So far I've created a simple macro then added code to it thinking this would work. Nope! I got "this will reset project" which looks to wipe out the shortcut. I've also looked...

Hello everyone, I was hoping to have some help changing the following code. I would like the end product to insert a column between a dynamic range of existing columns with the following equation in each cell within the new columns. The data table start off looking like this: <tbody> Well...

I am new here and basically no knowledge in Macro for excel. I wonder if you can help me insert an existing excel template to an existing workbook. Is it possible this way? Open the Template to be use Click the button in the template After clicking the button it will let you browse to a file...