title

  1. J

    Change cell bases on contents of another cell

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

    Formula to Lookup Based on Value and Return Data Based on Value

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

    ? To Print Relevant Year on Spreadsheet, pls (Excel 2010)

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

    Extracting items from cells based on one criteria

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

    what is wrong with my code

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

    Copying from one worksheet to another with added complications

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

    Cell contents based on another cell data

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

    Artist - Title Excel table (Billboard)

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

    Chart title link to slicer

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

    set raw as inactive to use second title

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

    Macro to export range to seperate sheet XLS format

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

    Run-time error '91': Object variable or With block variable not set

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

    Formula excel with several conditions

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

    Converting excel sheet from one format to required format

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

    Capture cell data into other cell

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

    If cell is not blank, add it to the cell below. Those cells are linked to another Sheet

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

    Page Setup: Title Rows, Header and Footer with References

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

    Hide Rows just before file is saved via commandbutton doesn't work

    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 ....|_|...
  19. R

    VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

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

    Pivot chart, removing row label title

    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!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top