title

Good Morning, I have a list of approximately 100 names. Every morning they clock in to a finger print scanner. I receive this as a simple excel spreadsheet which shows their name and clock in time. I need to be able to add a extra cell next to their name with their job title so that I can...

Hello, I am needing help with a complex lookup formula. I have a table of data with information in it shown below. [/URL][/IMG] So on sheet 1. I have a drop down with all the work cells listed. Whenever I select the title from the drop down, I want a formula to find that title in Row 1 then...

How do I get the YEAR (related to the workbook, not the date of printing) printed in the same Header/Footer as the Tab title, on all sheets, if that's possible, please? The relevant year, ie 2019, will be inserted on one sheet (Summary, Cell B4), which I will route thru to all the other sheets...

Hi All, Happy belated new years greetings to you all. I need your help on my query. I have 2 spreadsheets. Spreadsheet 1 is the main register and Spreadsheet 2 is a schedule. Linking all required details from S1 to S2 is ok using VLOOKUP function except for the last part of the schedule...

this code will print a selection with title rows only from page 2 it stops at this .PrintTitleRows = Selection.Rows("5:7") Sub printonlyselection() Dim lPages As Long lPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") With ActiveSheet.PageSetup Selection.PrintOut From:=1, To:=1...

Ok, I am trying to figure out a way to move records from one worksheet to another, my biggest problem is: Each row in the source worksheet can have up to 3 records, and those records have identical column header titles. I also only want to pull certain columns over to new worksheet. Here's how...

Hi All I have a worksheet that shows a whole load of data summarised in the table below. Worksheet 1 <tbody> Code Sub Code Sub Sub Code Details A Title A 1 Sub Title A1 a Sub Sub Title A1a b Sub Sub Title A1b B Title B 1 Sub Title B1 a Sub Sub Title B1a 2 Sub...

Hi Guys , Can anybody help me with this please? I would like to take this data to excel sheet . https://www.billboard.com/charts/dance-club-play-songs/1976-09-11 it is very time consuming to do it manually. I would like to have Artist in one column and title on the next column if possible. if...

Hi all I have searched the forum for Dynamic Chart Title, but all I've found is the standard link to a cell or a formula linked to a cell. I have a chart based on a pivot table, and a Slicer based on one of the fields, Clinician. I should like the chart title to include the name of the...

I have a linked excel table with 2 title line at the top! Top line shows full title description which are long and irregular! The second line in my SQL field names! Is there a way to render the second line inactive and not included in and crosstab activities or anything else for that matter...

Okay, I am not quite sure to explain this, but here goes: When I run this marco It takes the range 2 - 6 and across filled with data. It exports the files as Title 01.xls. The name is obtained from the A1 Then same happens for Title 02 and all the USED rage beneath it. The VBA look for one...

Hello, We are seeing this error only on one computer. All 6 pc's are running same version Excel 2016. When we execute the macro below the error occurs at the "With OutlApp.CreateItem(0)" area. Any ideas? Thank you Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim...

On a sheet1 I have some supporting data, in A1, A2 and A3 the titles; and in B1, B2 and B3, the quantities. On sheet2 some operations with formulas. I want to achieve the following: In A1 (sheet2), using a formula that includes the title that is in A1 (sheet1), but with the following...

Dear Friends, It would be helpful if someone can help me with following issue. I have an excel sheet attached in the below link. I have two sheets one which i recieve as an input(org). This input sheet should be converted into another sheet(sheet 3) of different format with datas from the...

Hi, Im sure the title is like others, but I couldnt find a solution and couldnt think of another title. :0) This is my dilemma. I pull a value into a cell everyday by way of formula. I need to start collecting this number in a historical way, so I can identify the change patterns. Example...

Hello Network, I'm facing now a task, where I need to linked a cell to another cells, for example: sheet 1 has a title in B2 Sheet 2 has a column C. C3 is actually a list where this titles need to appear. fIRST, let say the column C is from 2 until 10 (row)S So, if I add a title in B2 but...

I'm trying to use .PageSetup to get a few pages in a workbook ready for print, but I'm having trouble getting the expected response with Title Rows, and I can't find a good code example for using VBA to insert a header (and footer) with cell references. Below is the code that I have, and I need...

Ok, I'm getting nuts. I have an Excel file with Checkboxes on sheet 'RBD' I have a checkbox for each title. And each title has several checkboxes for the options |_| ANIMALS ....|_| Cow ....|_| Pig ....|_| Chicken ....|_| Other |_| FLOWERS ....|_| Rose ....|_| Tulip ....|_|...

I'm fairly new to VBA. I'm trying to split a worksheet into multiple workbooks based on the value in Column A. I can get the code to work slightly using the some older code I found below but it stalls on a couple issues: 1. The sheet I have has 4 rows of titles, even with the code identifying...

Hello, I'm trying to remove the row label title from my pivot chart horizontal axis without removing the row labels that describe each columns themselves. How do I do this? Thanks for your help!