excel

Hello! I've tried everything here and I hope you folks can help me. I have a spreadsheet with several tabs. On each tab, I've defined a named range for the tab. For example, on my Sales Sheet tab, I have the named range called SALES_SHEET. I also have Additional Pages-1 through -8...

I have a large dataset with street addresses (in column A) than can look like this: Streetname 15 (this is the street name and number of the street) Streetname 16 A (street name + number + entrance) Streetname 17 C Apt 1001 (streetname + number + entrance + apartement number) Streetname 18 Apt...

Hello The below code moves rows of data to an archive sheet when they become 6 months old (as of the current date). Could someone help me change it so it moves the data as values, rather than formulas? Private Sub Workbook_Open() Application.ScreenUpdating = False 'Set...

I have been working on this for two days and cannot get the formatting details to come through on the pdf being attached to an email. All of the data is there but it is useless without the formatting Option Explicit Sub CreateAndEmailPDF() Dim wsSource As Worksheet, wsTemp As Worksheet...

I have a workbook with multiple sheets with the same tables design and conditional formatting, and because sometime I face some drops in applying conditional format is some sheets, so I recorded a macro to copy the first row from a sheet that I see that it's stable "Ivory" and paste only...

Hi, I have used the following formula to summarise the top 100 of total number of hours recorded within a period: SUM(LARGE(FILTER(Data[HOURS];Data[PERIOD]=[@PERIOD]);SEQUENCE(100))) In a seperate column I have a COST associated with said hours and I'm trying to figure out how I can get the...

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...