history

  1. D

    Concatenate function

    I am trying to add text using the concatenate function....for example=concatenate(a2,b2,c2) which works fine however if I try this =concatenate(a2:c2) comes back with a hashVALUE error....but...... What I am trying to achieve is to extract data from a report which gives me the subject the...
  2. D

    Maintaining Historical Data

    QUESTION: I'm doing a preventative maintenance spreadsheet. When I complete a task on a particular date, I put the date in that I've completed it in column "B" (for example) and a new "due date" appears in column "B". Is there a way to keep a record on another worksheet that will maintain a...
  3. S

    Clipboard History issue in VB Editor

    If I use Clipboard History in the VB Editor, the text content of the clipboard is hidden unless the Copy was done in Notepad or equivalent. Copies done in VBE paste OK, but you're pasting blind, which is useless My problem is that I work in VBE most of the time, and I've never been able to...
  4. D

    Lookup text in one column, return date from same row in different column

    Using Excel 2016. In the GMH Table, I am attempting to Lookup "Gas Tank Fill" in Event column of the History Table to return the date from same row in the Out column of the History Table using a table that will advance the formula when the next row is added. =LOOKUP("Gas Tank...
  5. F

    Conditional Format query

    Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this: <tbody> Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 Choice 6 Option W Option X Option Y Option Z History Spanish Media RS PE Art History Spanish Art RS...
  6. R

    Help

    Hi Everyone, I'm stuck and was wondering if anyone can help. I have the students name in Column A. In Columns B, C & D is the subject choice. The student will only have one subject choice in columns B, C or D. In column "E" I want to record the subject picked. Example: A...
  7. T

    Remove data from one sheet and add it to another according to date

    Hi Everyone, I'm need a macro to help me remove events that are past a date i choose so i can "Arcive" them. so heres what I need Sheet "Diary" holds the data i want to move Sheet "History" is where i want it to go Sheet "Diary" Column A has the event dates Sheet "History" Cell A1 has the...
  8. dmxcasper2

    Need ideas for history tracking fro specific cells

    Hi all, I need some ideas for tracking the historical changing values. Problem Statement: Column H and I will be revised multiple times throughout daily maintenance of this sheet, however I would like to be able to keep historical snapshots of what the previous information was in these columns...
  9. F

    Counting the frequency of a value used in a formula

    Hi all, I'm trying to calculate the frequency a value is used in a formula. I have a range of results (ranging numerically from 1-9) each connected to a topic/subject. I have created a cell which identifies the largest number amongst those results in every row (=LARGE(S5:AN5,{1{)). What i'm...
  10. N

    Hide/ Unhide - xlSheetVeryHidden

    Hi, I am looking to hide an array of worksheets as shown below; Worksheets(Array("Data Log", "Rev. History", "Visual Set Point")).Visible = False This works great to hide the worksheets, however what I am really looking to do is, very hide the worksheets, something like this...
  11. E

    Capture and display the cell number being double click as a History record

    Hi All expert, Can I check with you.. As I have a Tools booking system. However, notice, people book already and then unbook later. So I want to track who double click the cell to unbook. How? I intend to record down the action that the user did in the form. Now I can record down the user name...
  12. F

    copy cells from columns A to C to next non-blank cell

    Another day another plea for help :) I have a spreadsheet with 255,398 rows. Each student has anything between 5 to a 1000 rows, however, not each row has the student's details. So the table (in a very simplified form) looks something like this <tbody> Surname Forename UPN Achievement...
  13. S

    In depth checking of two excel lists

    Some Background We provide a software system to organisation to manage their grant making processes. Our online system removes laborious paper centric practices and moves this all online. When a client signs up with us, we need to import a history (3 years) of their grants so that when...
  14. W

    VBA array loop nesting

    Hey yall. Long time no see. I must be out of practice. Can yall help me out with a thing I'm working on for my job? I shrank the code down and the input data so that it wouldn't be too much too read. I only left the relevant code and relevant input data. Data is in Microsoft word; However...
  15. M

    Can I copy-and-paste old data from my table into a values-only table, and then use that in my time series chart?

    I have an Excel table called DailyBalances that uses several SUMIF functions to other tables in my workbook to calculate values for each day. As time goes on this table is getting larger and larger and execution time is getting slower and slower. So what I want to do is every month or so I want...
  16. R

    Excel-Move Rows to another sheet based on Cell Value

    Hello. I am needing help with code that will move specific rows to another sheet in the same workbook based on a Cell Value. In my workbook, I have a sheet named "Notes" that has values in Columns A-C. I need a code that when I enter the letter "X" in column D, it will copy the contents of A-C...
  17. S

    Is it possible to FORCE a pivot table to keep old data?

    I have read a number of posts about changing the "retain items deleted from the data source" setting. This may work well for getting rid of the old data, but it setting it to Automatic or Max does not seem to FORCE the pivot table to keep old data. I am looking for a non-macro...
  18. H

    creating a chart for tracking history prices

    Hi I need to create a chart using excel to track the supplier history prices. To make it easier for you to understand my thread, I'll give an example: let's say the supplier set a prices for a specific product as following: Nov 07, 2017 $30 Nov 15,2017 $20 Dec 20,2017 $29 Now, the idea is...
  19. N

    Excel shared with change history

    I have a file that I need to share amongst numerous people who will be given a password to modify. I need to be able to see history of any changes made to various cells / ranges within the file along with who made the changes (login ID from computer is fine). Is this possible to do? Thanks,
  20. G

    Execute Copy & Paste whilst a conditon is met on variable length data

    The problem I am trying to solve is to write a macro, that copies their name against each course they attend. I have over 600 students, and the student names change on a monthly basis. There is always a space between the last course and next student name. Any pointers welcomed! <tbody> Column...

Some videos you may like

This Week's Hot Topics

Top