history

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

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

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

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

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,

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

Ive got an excel workbook im editting (updating data, formulas, delete sheets etc) prior to being sent on to a 3rd party. I worried about them being able to see the edits that ive made, is that possible ? Ive got track changes turned off. Would it still be possible for them to see the revision...

Thanks in advance for your help. I am looking for a macro/function that does below: Column 1 : Has comments that I add in each day Column 2 : Maintain the history of all comments form the past When I add a comment in Column 1 , And when I press a button or automatically when I go away from...

Hi Folks, Can you please help me with the below query: Master Data: <colgroup><col><col span="2"></colgroup><tbody> Username Subject Score A1 English 50 A1 Maths 45 A1 Physics 34 A1 History 23 A1 Geography 56 A2 English 24 A2 Maths 67 A2 Physics 45 A2 History 32 A3...

Quick Question, In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected. Is there any possible way...

I'm not sure which section to post this in, any advice on a more appropriate forum is appreciated. I am trying to create a master inventory worksheet for a small business - one that can auto populate the data into a separate worksheet to analyze sales history and then re-clear the master...

Hi, i hope someone can help me as this is driving me potty. I have student grades listed like below <!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody> Biology Chemistry History Physics Student 1 6 7 7 2 Student 2 3...

Hi all! I have a spreadsheet that I use to track versions of multiple applications for multiple clients. I was hoping to be able to keep a history of the previous version number in a different worksheet(i.e. app1 version history, app2 version history, etc.) upon change to the current version...

Hi, I was working on a spreadsheet for work. I wanted to make a dropdown list where I am able to type text in the dropdown box. I then need to update the dropdown every week. I also need the previous entries to appear when I click on the arrow. For example: Week 1: Drop dow list has 1 entered...

G]C:\Users\ShelH\Desktop\Access1[/IMG] here is the query code here is the whole SQL query coding SELECT [Trans Rvsd6292017].emplid, [Trans Rvsd6292017].gender, [Trans Rvsd6292017].dob, [Trans Rvsd6292017].name, [Trans Rvsd6292017].stint, [Trans Rvsd6292017].effdt, [Trans...

I hope I can explain this clearly in words as it is in my mind!:) Lets say I have C2, D2 and E2 as my cells for vendor costs, IT costs, Employee costs (or whatever, the actual table has a lot more components) B2 is just summing these up. So B2= sum(C2:E2) in this case. The thing is as I get...

I have a PivotChart that shows the target date of certain action items as well as the % completion of those action items. I've also included a progress bar showing the current date, and all of this information gets updated with a refresh click. What I want to be able to do is cycle through the...

I am trying to create a way to recall the data that has been input into my excel by my userform. I have looked EVERYWHERE and nothing works i need help. vLookup doesnt seem to work for me or im not using it right. Essentially i have 2 Userforms Userform1 = Input Form Userform2 = Recall Form I...

Hello - i am new to access and i need some help. I am working with a custom UI tool that creates an Excel extract upon request. I run this excel report daily to perform calculations on changes. I have past excel snapshots on my PC. I want to use Access to store the daily data, that way i can...

Hi there and thanks in advance for any help and tips. So I am new to VBA and have just started playing around with it about two weeks ago. I have been searching and haven't been able to find a solution for the problem I am hoping to solve. I have two folders. The name of the first folder is...