follow

  1. M

    IF function help, potentially a different formula woudl work easier

    Hello, I have been searching this forum and youtube all day to figure out this issue. Sorry if this is a repeat. My scenario: I am attempting to do a crosswalk. Basically comparing a legacy system data to an upgraded new system. I am trying to create a formula in the "Proposed S2...
  2. M

    create follow up dates within spreadsheet

    Hi there, I have an excel spreadsheet going that has our new members entered each day. The date the member is entered is the first column. I would like excel to use the date the member is entered and move or copy all the information in that row to another sheet for a follow up. each follow up...
  3. M

    basic formulas

    Hello, I am using Win 10, and an alternative to microsoft excel called PlanMaker since I dont have a copy of microsoft excel. I have had trouble trying to post an example of the data so I will try to explain with a picture and a brief description. I need help with simple formulas, working...
  4. D

    HTM file into Excel has two header titles

    I have copy and pasted a HTM file into Excel. The headers and information is stacked onto two lines on the original report. I need the headers to be separated onto one line and the two lines of information to follow the header it is attached to. example below. the yellow below should follow...
  5. J

    I want -452 into a formula that shows (452 down)

    Hello everyone, I hope the titles made sense because I do not know how to explain it. So what I would like is to get my formula to not show the minus sign into the bracket. <tbody> Movements PPPP OOOO XXXX ZZZZ -452 -184 -6 20 (-452 down on last week) 27 -47 -38 11 (27...
  6. L

    combo chart in excel 2010

    Hi I am trying to follow the instructions on how to combine 2 charts in excel (please see the link below). I am using excel 2010. Can I do what the author did in that article using excel 2010. Thanks a lot. https://www.guru99.com/creating-advanced-charts-in-excel.html
  7. S

    Copy/Paste variable length rows

    I have read several similar posts, but none seem to work for what I'm doing. Seems simple, yet I can't figure it out. I have thousands of rows in a spreadsheet and 150 unique id's in col. A. The rows that follow each unique number are variable. For example, empl. 502 has 26 rows, followed by...
  8. J

    If Then Else Highlight

    I have searched the forum and the internet, but all I have found is conditional formatting which does not appear to do what I want. I have a column into which either a "Y" or "N" will be placed and if "Y" I would like a highlight of the adjacent cell as a reminder for me to do a follow up...
  9. J

    Command Button Programming

    Good evening all. I am trying to create a command button that will do the following: There are potentially a large number of rows There are 9 columns of sortable data I want to copy each row (the entire row) to a separate sheet as a summary page which has the condition of the Follow up date...
  10. M

    Quick Tab Renaming and Maintaining Hyperlinks with the Name Change

    Good Afternoon and thanks in advance for any help! I am working with a 500 page workbook.:eeek: Every year the tabs have to be renamed to match the date of Friday each week. The first page of the workbook is a directory with hyperlinks to all other tabs. Q1. How can I quickly rename 500...
  11. J

    Follow Hyperlink Macro only works in Pause/Break Mode

    Hello.</SPAN> As part of a macro I am working on, I would like Excel to follow/open a hyperlink to another Excel workbook.</SPAN> When I CLICK ON THE HYPERLINK in the workbook, I get the warning about making sure the file is from a trustworthy source, I hit ok, and the workbook file opens just...
  12. Pinaceous

    Excel macro imports dynamic query into table need rows to follow

    Okay, I have a macro which imports dynamic query information in compiling a time ordered list. The macro then advance filters this query list and posts the information of which is returned onto sheet 1 via table with the desired information for the input user. The macro works great, where the...
  13. J

    How to follow hyperlink with keyboard?

    Hello all In a previous version of Excel (or with the help of an add-in or macro) it was possible to hit the ENTER key (after selection of a a cell that contains a hyperlink), on which Excel did follow that link (to a cell, sheet, file, internet, whatever). I cannot find this "function" in...

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