excel

I am using office 365..current access db is saved as 2007-2016 format...and excel file is 97-2003 format. I have the below code working, but it gets very slow as the process reaches 300, 400, 500 generations of separate files. I have approx 3K + files a month to generate unfortunately. Any...

Hi all, I want to attach multiple worksheets in one email but it has the duplicate attachment problem as attached image Would anyone can help? Thank you very much Below is my code: Sub Create_Site_Cable_Usage_AT() Set wSheetStart = ThisWorkbook.Sheets("In out record_AT") Dim LastRow As...

Hi All, I would like a to get a VBA code that, once I press it, looks at cell D5 and then copy pastes the formula from BW34:BW36 to BX34:BX3, as well as from BX41:BX50, because cell BX6 is >= 2. The next month, when cell D6 is updated to the number 3, it should update column BY as well. Please...

Hi all I'm new on this forum, but have a little experience with Excel VBA coding. I struggle to find out what is causing a certain behaviour. When running the code below, which is started with a Button on sheet 1, the graphs on sheet 2 are changed. ActiveWorkbook.SaveAs fileName:= _...

Hi all, Sorry if this question is has been asked repeatedly. I picked up Excel and Access after my coworker abruptly left and while I have done a decent job adapting, there is one error I can't manage to stamp out and it seems to grow every time I update the data base. The database is made up of...

I need help writing a formula that will search a string and return the first instance of two characters only, between two underscores. Probably not explaining that well but my examples are: abcd_ef_gh_ijkl this should return ef abc_efgh_ijk_lm_nop this should return lm My current formula...

I have workbook with power query queries. I'm trying to get currency rates into yellow column, based on parameters specified in green column (currency symbol) and blue column (date). Query refer to internet csv, updated every workday, so I would prefer to not downloading full data table into...

Hello, Looking to find a solution that is repeatable for the data manipulation below in the screen print. My company will not allow me to add the XL2BB addin so this is the best I can do. The data in the "Currently" section is from a our master database, but no one likes the way it looks with...

(One more before I quit for the day and what a gloomy day here in England) I am counting the occurrences of items on a sheet and outputting by counts each day: countif of unique items by date: =COUNTIFS(Sheet22!C:C,B5#,Sheet22!A:A,Sheet21!E4:Sheet21!I4) - b5# is list of unique items on Sheet22...

I may have already answered my own question but I have just discovered xl2bb so I will post anyway: when I say answered this only means that I won't (please correct me here) be able to achieve what I want by sorting alone so will need to think on or look for guidance/answers here. (Not sure...

I am new to macros/VBAs so I'm looking for help in writing this code. I have a spreadsheet that is used as a data source (SourceFile), which contains data in Columns F, H, and I. I would like to copy the entire column of all three columns and INSERT them into multiple workbooks that are saved...

Trying to get the text at the bottom of the graph to align with the bars. Can someone please tell me how I can format it so that the text at the bottom aligns with the bars? I have tried everything and cannot work out what I have done wrong. TIA for any advice/assistance

My husband has a spreadsheet with rows of varying height, when he sorts his information the row heightd do not change. Apart from selecting the whole sheet and using Format - Autofit Row Height is there any other way of keeping row heights when sorting. If this has been answered before...

It seems that Autocomplete text in excel works only in the same current page of excel sheet while when I go down to a new page, it doesn't work I works on a daily list of tasts where I need to assign a team member in front of each task and as the team names are almost the same people so I need...

I am trying to make a power saving model to lower the total power bill, with a primary goal to find the trigger price at which the power saving starts. Logic elements: When the power in the hour exceeds the price trigger, then power saving starts, BUT The constraint is over the period, there's...

Hello, I'm trying to create VBA code that converts all current formulas in cells to text values and save the entire sheet to a new XLS file. For this purpose I've used the following VBA code, but it doesn't do what I want. The newly created XLS file still contains formulas in the cells. I...

Hello! I am currently doing my dissertation and I am trying to get my data from Excel into SPSS. However I have quite a lot of quantitative data that I need to turn into numbers to do this. I’m just wondering how I turn a mass amount of qualitative data in Excel into numbers so that I can put...

I have found a code and modified it to perform my need which is to cycle the drop down list in a sheet and save the filtered data as PDFs in external folder with the currant date after the file name. but because the curranet date is changable of course, the folder still keeping the last time...

I have an excel vba userform from which I connect to an adodb (ms access), But I am trying to filter on the date (Datum) field. Both via sql statement or the recordset.filter method but neither seems to work. Here is my code: Private Sub UserForm_Initialize() Dim con As Object Dim...