Recording Info On Weekly Basis
Nov 17, 2008
I have a training matrix. The following letters represent something F, P & S. and are placed in the matrix. On a seperate sheet I calculate these using the COUNTIF(B2:E7,"F") so on and so on. This is done because the matrix is quite vast and to sit and look through would take an age and I'm already nearly retired lol.
1st question:
Also in the matrix are dates when a student has finally passed a subject is it possible to use the same formula to calculate all these .
2nd question:
I also want to be able to record on a weekly basis how many new subjects have been trained out but don't know where to start . i would like a chart indicating for instance Week 1 5 subjects, Week 2 25 subjects. What i don't want to happen though is when you add Weeks 2 data for Week 1's to increase with it.
View 9 Replies
ADVERTISEMENT
Apr 21, 2014
I am looking for a formula to calculate overtime on a weekly basis, entered daily, on a sheet with multiple weeks. It need it to calculate the overtime each week.
View 8 Replies
View Related
Dec 10, 2013
I am trying to make my excel sheet more robust to get data on weekly basis. I assign tasks to different members of team by entering the assigned date in column next to the member names. Next week, say on Monday, I need to get total number of tasks assigned for each of the members till Friday (last working day of previous week!). I need to get this data every week.
View 8 Replies
View Related
Aug 13, 2013
I have a folder set up on a network drive which contains a workbook for each member of staff (approx 40) to track queries that they receive on a weekly basis Each one of these is called "Query database - Joe" for example. The queries are stored on a worksheet called "Query data" within this workbook and they need to be collated on a weekly basis on a Monday morning and cut and pasted into a master database worksheet again called "Query data" to then carry out analysis on these.
What I am looking to do is have a macro set up that will automatically cut and paste the data that has been input onto each individual worksheet into the master spreadsheet, starting from the next blank line. Each option I have found seems to be set to copy a specific range, or paste to the start of a worksheet each time, rather than finding all of the 'new' data that is there for that week and then adding it to the bottom of the master sheet.
View 9 Replies
View Related
May 5, 2006
Need the formula to enable a cell to automatically update the date on a weekly basis
View 2 Replies
View Related
Apr 26, 2013
I have a shared document used by as many as 11 different people. right now I go into a document and save a copy each week in case one of them messes it up.
just curious if that can be done automatically.
View 3 Replies
View Related
Jun 19, 2007
In the attached workbook, the CASTINGS worksheet has a SOH ( stock on hand) column.
It looks up the SOH from the SOH worksheet (column 3) for each product on order for that week.
But how do I make week 2 use the SOH figure minus the previous weeks order, IF there was an order?
And so on until week 52.
The problem I have found is what if that product wasnt ordered for the last 4 weeks? Maybe I need a temp worksheet with all the products listed for all the weeks and a running total of SOH weather it is ordered or not?
View 5 Replies
View Related
May 12, 2014
I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies
View Related
Aug 22, 2014
I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
View 1 Replies
View Related
Oct 18, 2009
I have a function, that one of the members in this forum wrote. that changes the title of a chart according to the text that is written in a specific cell. I added this code to a module: ...
View 12 Replies
View Related
Jul 18, 2009
when i recored Macro i try to select cell A1 and write in It Yahya the Code Come Like this one ...
View 9 Replies
View Related
Aug 29, 2009
I have a spread sheet in excel that I enter a date(a1) the supplier(b1) product ordered (d1) and an order number(g1) when I record a macro to copy theses cells in to a sheet called a purchase order sheet (i.e. A1,B1,D1,G1) the macro runs and prints off the order sheet how do I get the macro to run when I fill in line (A2 etc) when I enter a new order.
View 9 Replies
View Related
Feb 5, 2007
cell A3 contains a drop down list of student names.
say, William is the 1st student listed on cell A1.
when William is selected his math grade shows up on cell B3 & his English grade on cell C3
I figured out how to make cells B3 & C3 change according to selected student from cell A3. All data comes from the Database Table, which is locked/unedittable.
Here is how my sheet looks like ....
View 14 Replies
View Related
May 8, 2009
Is there a way to copy/transfer a cell value to an adjacent cell when the value of the cell changes. So if A1= 5, and it changes to 3, have B2 = 5 when this happens.
View 14 Replies
View Related
Feb 13, 2010
Some of the below address was removed, how would this formula be written in VBA? When I try to record this formula excel tells me unable to record, probably due to all the & within the address itself ...
View 9 Replies
View Related
Oct 31, 2013
I have an excel file emailed to me everyday. It is a daily tracking of our fleet and I manipulate it before printing it and giving it to management. I dont know why when I try to record the macro and then use it it hides all columns.
The report has columns A-N. I hide B, F-G, I, M-N. When recording I hide multiple columns across.
I have done similar macros with other reports, no problem.
View 5 Replies
View Related
Jan 30, 2009
how can i record a cell's value on a different tab every x seconds?
the value is updated every y seconds and i would like a list in column A of the cell's changing values.
every refresh may produce the same value.
View 9 Replies
View Related
Feb 23, 2003
I have a DDE-based worksheet, that is obtaining data from Townsend Analytics' RealTick Server software. One of my cells is a DDE formula that retrieves the current BID ask price, for a given stock.
When a new BID price comes in to my designated cell, I need to somehow capture the existing BID price, before this new one updates in the requisite cell. I want to be able to store this "old" value in another cell.
Unfortunately, there is no "pre-cell" event trapping. I've tried to work with the worksheet_change event, which passes an argument of the effected cells, but the cell value has already changed, by the time this event has been called.
This problem sounds simple, but I am at a loss for a solution. Does anybody out there in EXCEL-land have a solution ?
View 9 Replies
View Related
Jul 7, 2006
This problem occurs in EXCEL 2000/2002/2003. I open a CSV file generated by perform.exe and convert the information using Data/TextToCollumns - Delimited/Colon and Finish. When i execute these steps in Excel i don´t have problem, but when repeat these steps after recording a macro (Tools/Macro/Recording Macro) occurs this problem.
After a click finish option, i receveid this message
"Numero excessivo de continuações de linhas" (Portuguese message)
"Excessive Continuation lines" ( translate to English )
and recording macro stop. I don´t know what happen. I attach a ZIP file with a CSV file to test and analysis.
View 2 Replies
View Related
Mar 14, 2007
On my spreadsheet I want to move a column at the start of the day (as one column is todays values, the one previous is yesterdays). I have tried the following but it doesnt like it:-
Sub RQV()
Dim warn As Integer
warn = MsgBox("Do you wish to move RQV data to yesterday?", vbYesNoCancel)
Sheet1. Unprotect
Range("F2:F65536").Select
Selection.Cut
Range("E2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheet1.Protect
End Sub
It comes out with a run time error 1004? It needs to be a paste special as I just want the values put in. I have tried recording a macro to see how the vba code works, but it doesnt give me the option to paste special for some reason and I presume this is why the error occurs.
View 9 Replies
View Related
May 15, 2007
I frequently use the record option to start off my macros. I realize this usually results in recorded events which are not absolutely necessary (recording a print macro is one that is full of excess line items). I then try and combine what I have recorded with what I have garnered from this wonderful website. If my spreadsheets are small - and I am not writing code to pass any inspections - is there a need to go back and clean up?
View 2 Replies
View Related
Oct 21, 2009
The code contain using Autofilter to some columns, & then copy paste to another sheet to first blank row, & sorting it by asscending in Column A.
Both sheets are in the same workbook.
But for some reason, the Macro will giving the result expected if i run it step by step (by using F8 button under window VB editor). And if i call the Macro name it stoped in the middle of the process.
View 7 Replies
View Related
Feb 20, 2012
I incorporated more codes to the ones that were just solved from this board, but how can I make the active cell stay on A1 of sheet "hypo_tax_dropdown"? Also, I obtained the codes for removing the duplicates from macro recording, will these codes work on any machine? I noticed that it doesn't have worksheet.function
Sub Macro1()
Dim X As Long
Sheets("Hypo_tax").Select
[Code].....
View 7 Replies
View Related
Sep 22, 2012
Say i wanted to track the changes in a cell, i.e. if a number changes in a cell it records the new number in a new column. The following macro achieves this for one value; say type a value in a15, it records the number changes in column D;
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DestCell As Range
With Target
If .Cells.Count > 1 Then Exit Sub
If Intersect(.Cells, Me.Range("a15")) Is Nothing Then Exit Sub
If IsEmpty(.Value) Then Exit Sub
If IsError(.Value) Then Exit Sub
[code]...
But what if need to track the value of 4 cell changes in different columns, and record these values into different colums of their own? So for example, if i had a value in a1, and wanted to paste the changes into D; if i had a value in a2, and wanted to paste the changes into E; if i had a value in b7, and wanted to paste/record the changes into F etc etc.
I thought about running the macro for each cell but it wont work, for example i tried;
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DestCell As Range
With Target
If .Cells.Count > 1 Then Exit Sub
If Intersect(.Cells, Me.Range("a1")) Is Nothing Then Exit Sub
If IsEmpty(.Value) Then Exit Sub
If IsError(.Value) Then Exit Sub
[code]...
View 6 Replies
View Related
Sep 26, 2013
I am having trouble with a project for school. The instructions are: (In Worksheet 1) Type Your Name. Now, begin recording a Macro. Copy and Paste your name from Worksheet 1 to Worksheet 2. Fill in the background and edit the font. End.
Here is an example of the coding.
ActiveCell.Range("A1:E1").Select
Selection.Copy
ActiveSheet.Paste
Application.CutCopyMode = False
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
[Code] .....
Now, according to the instructions I should be able to run the Macro in any worksheet....but anytime I run the Macro in any other worksheet I just get a yellow block without my name there.
View 4 Replies
View Related
Nov 17, 2006
I'm recording a Macro but I want to test certain section before I complete it, so can I pause the recording and then restart the recording again?
View 9 Replies
View Related
Jun 28, 2007
When I try to record macro, the small toolbar which has two buttons "stop recording" and "relative reference" do not appear. I need to turn relative reference on.
Can you please guide me how can I make it visible to turn relative reference on?
View 9 Replies
View Related
Jul 13, 2005
In A2 is the Stock price, and B2 the time of the update.Now every time it updates A2 and B2 get overwritten.I need some code that will save/ record the the stock price on the hour, every hour. I then need the highest and the lowest price within that hour, and lastly the price at the very end of that hour. (example)
A.........B.................C.........D.........E...........F..........G
stock...time.............time......open....high.......low.......Close
.60......16:45:33......14:00....40........90.........30........60
............................15:00....65........78.........65........62
............................16:00....62........72.........58........58
I received what I think may work, but I dont know how to write this in VBA. If the time of the new value received > than B2 + 1 second, create new row where Open=High=Low=Close else if (last column=new value,if new value>high column then high column=new value,if new value<low coulmn then low column=new value.)
View 9 Replies
View Related
May 12, 2007
I'm trying to create a macro using Tools/Macro/ Record a New Macro. I need to record in the relative mode, but I cannot find the Relative/Absolute button. I have gone to Tools/Macro/Stop Recording but it only allows me to stop recording. I am on excel 2002
View 3 Replies
View Related
Feb 20, 2009
I have a huge list of accruals and payments. Accruals (positive) are entered, and at a later date are offset by the payments (negative). Im trying to make a schedule so i can determine which are left over.
This is easy to do manually for a small amount of rows. However im dealing with 5000 rows and i do not want to manually match it would take many days to do.
Ive tried a duplicate remover. To get it to work i made an absolute value column for the negatives, and compared it to the positives column to find the duplicates. This works to a point. However, If i have three accruals for 100, and one payment for 100, all are identified as duplicates which obviously is not what im looking for.
I need to get it where one accrual is matched to one payment. if there are 3 accruals, 2 payments, 1 is not a duplicate. if there is 3 accruals, 1 payment, 2 are not duplicates.
View 9 Replies
View Related
