title

Hello, I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that? <tbody> Title 1...

My source data includes File #, Name and Title. There are up to 10 Name/Titles associated with each File#, and the Names are often repeated with a different Title in each File. I need to show all the data by File #. Lookup only picks up one data set per file. Can you help? Thank you...

Hi, Recently I have Office 365 and also SharePoint with the new "Team Sites" environment (previously called workgroups). Anyhow, I have a macro which convert the excel sheet into pdf and puts this pdf in an email ready to send. This is the coding : sub sendPDF() Dim OutlookApp As Object...

HI everyone, im requesting you help to understand the followin issue, im learning about VBA and most of my formulas are translated into VBA by using the recorder, but with this one: =IF(A2="Dash Record"," -PO Title: "&CHAR(10)&B2&CHAR(10)&" -Item Description: "&CHAR(10)&U1&CHAR(10)&" -Cost...

Hi, please help. My original table is: Row <tbody> 1 Title 1 2 Description1 3 Title 2 4 Description 2 5 Title 3 6 Description 3 </tbody> I need the following result: <tbody> A B C Title1 Title 2 Title 3 Description 1 Description 2 Description3 </tbody> I appreciate your...

Hi Can someone help with how to have a single cell automatically update daily from a range. So i have a worksheet for each day of the month and the equipment used can change daily. Currently the identification of the equipment is taken from multiple cells My issue is this then forms a dynamic...

I have a large amount of data on an Excel worksheet, 4000 rows. The data is split into sections, each section with a title in column D. I am trying, without success to compile an interactive index on a separate worksheet. The Index will comprise only a list of the section titles and I want to...

Hoping someone can help I understand how to make a chart title dynamic. What I want to be able to do is Have a chart title automatically update from a different cell each day I have over 100 charts and at the moment it is fine until on any given day in a month the title needs to change This...

I am trying to help a friend and I am confused by the results. In a separate column called "Avatar", they want to identify the role of each individual based on their title. For instance, if the title has the word SALES in it, they want the avatar to be SALES, if the title has the word MARKETING...

I will be opening CSV files that will be exported from another location. Some of the data columns are useless that comes through, so I want to delete them if the title contains specific text. I don't just want to delete the column based on location (i.e. delete column D regardless of what the...

Hi there, I am working on some reports – I need to replace the “name”with a query that goes through 67 names in a loop. DoCmd.OpenReport "Report - Change Month in Title eachtime", acViewPreview, "", "[Table]![Send ReportTo]=""name""", acNormal Below is my entire code thus far. I can get...

I have a script someone gave me to autogenerate a PowerPoint slide from within a workbook. However, I need to add a title box and value into the script and not a VBA guy at all. The script is below...can anyone help me out with the code to create the title box and populate it? I can modify...

Hi All I've been using Excel on Mac for many years and never had this issue till now. It's probably more that I don't understand than an issue. I have always been able to double click on sheets in Excel Objects, they would open in a window with a gray title bar and the option to close, min or...

How do I get a cell to pull in the tab or sheet name?

Hello, Is there a macro that I can use to set the case for a range of cells to Title Case? Thank you

Hello, I'm having a problem trying to develop a code that will enable me to automatically insert a row as enter is pressed. Sounds easy, problem is this needs to happen throughout the excel sheet. There are titles to drawing packages in the sheet, two blank spaces between each title. As...

Good Afternoon all, Is there a macro for copying data from Sheet 2 to Sheet 1. I have the day's horseracing cards on sheet 1 and I have the title of each race on sheet 2. I want to copy the race title for each race and paste it into the correct cell on sheet 1. Example...the first race title...

As the title states, how do I get the value of the date picker by debug.print. Thank you

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Cohort!$L$13:$L$2002,ROW(Cohort!$L$13:$L$2002)-MIN(ROW(Cohort!$L$13:$L$2002)),,1))*(Cohort!$L$13:$L$2002>5<21)) It works for =SUMPRODUCT(SUBTOTAL(3,OFFSET(Cohort!$L$13:$L$2002,ROW(Cohort!$L$13:$L$2002)-MIN(ROW(Cohort!$L$13:$L$2002)),,1))*(Cohort!$L$13:$L$2002<=5))...

<tbody> A B C 1 Special# Section Title Text 2 50 Title The system shall support [ =A2 ] cycles. 3 70 Title The system shall support [ =A3 ] cycles. </tbody> Hi All, I want to reference the values in cells A2 and A3 in the "Text" column. I would like it so that if I have to change the...