Move Record To Next Stage?
Jul 28, 2014
I have few stages. Starting from 1 to 6. If the task is completed in Stage 1 and when "F" Column is marked as "Completed" the records should be moved to Stage 2 without status (without F column value) and remove from Stage 1. It should happen while clicking the Save button which was created in Sheet 1.
I tried but i could not get the last record of Stage 2. find the last record and move the record from stage 1 to stage 2.
Attached excel file for reference.
View 4 Replies
ADVERTISEMENT
Oct 3, 2013
1. Want to findout in which stage the loan is ? Eg: 1212321231 is in PROCESSING STAGE because the date appears under processing .
2. want to find out how many stages it has paased ? Eg: Loan 1212321231 has passed 3 stages and now in 4th stage(processing).
View 7 Replies
View Related
May 21, 2013
I am looking to find the rider names of the first top 3 position for each stage in Results Page. The data comes from Stage Results. Initially I used Index and Match but to no avail.
Results Page
Stage 1
1
First
2
Second
3
Third
Stage ResultsA
B
C
D
(E)Position
1
Guy LeForge
Commage
6334.030
33
[Code] ..........
View 5 Replies
View Related
Dec 18, 2013
I have to maintain freight cost according to the shipment weight. Our shipper has different charges for different scale/quantity of shipment. For example, according to the attached picture; Rate for up to 10 Kilo is $ 20 per kilo. For weight more than 10 kilo and up to 20 kilo, Rate will be $ 15 per kilo and so on.
Now, suppose my shipment weight is 28 kilo. My cost will be $ 200 for 10 kg, $ 150 for next 10 kg and $ 80 for the last 8 kg. In total $ 430.
I have to calculate the total cost separately. I wonder if I could devise a formula by which I could put the weight in a single cell and get the freight cost instantly.
View 2 Replies
View Related
May 25, 2007
I seek advice on using the value of NOW() as a record ID in an address book program. Question #1: Do Excel developers often use a record ID? Question #2: What record ID schemes are fequently employed besides date/time? I have decided to create an Excel address book as an exercise to increase my knowledge of VBA, and also as a useful application for work.
I realize that a record ID is not essential in Excel in the way that it is essential in Access, but I feel the need to have some unique ID associated with each address, so that I may have different worksheets, with data related to a given Contact, sort and manipulate it, if necessary, but have the record ID as a way to restore the relationship of rows to a given Contact, and also, as a handy way to examine the data in the date/time sequence in which it was entered. I have experimented with the following code, to assure myself that I can access the number returned by the NOW() function, manipulate it as a string, and format in various ways if necessary.
Dim n As Double
n = Now()
sn = Str(n)
p = InStr(sn, ".")
first = Left(sn, (p - 1))
l = Len(sn)
d = l - p
S = Mid(sn, (p + 1), d)....................
View 2 Replies
View Related
Mar 16, 2014
I am creating an asset management sheet. For the formula I am trying to work out there uses 3 fields : ID, start date, and end date.
What I want to do is be able to show if the ID is duplicated within another record with an overlapping date. So an item is flagged if it is in the list within the same dates as another record. I tried a few countif formulas but with no success.. I may just be approaching the problem incorrectly though.
View 1 Replies
View Related
May 26, 2009
I am looking to create a macro that will create a new sheet when data is added on a summary sheet. Example.
1. Summary sheet called "Variations" contains columns that will contain the information needed for new sheet (Columns A to D)
2. When data is entered on "Variations" sheet: Column B, then macro automatically creates new sheet renamed to e.g. VO1 (Number used on "Variations" tab) and is a copy of "Master" tab.
3. Data entered in Column A to D on "Variations" tab is automatically entered onto new sheet created (e.g VO1). Shown is blue on attached file. Additional data is updated on "VO1" sheet and this then links back to "Variations" tab
View 6 Replies
View Related
Mar 20, 2009
I'm trying to find a macro that will run allowing the user to select a 'starting record number' and a 'finishing record number' when printing.
I have a spreadsheet that feeds from a master list in excel, from over 5000 records.
I need to print the s'sheet with any given indivdual record's information at any given time.
Individual prints are fine. However if I wanted to print from record number 1500 to record number 3000 it would take me all day.
Is there a way I can set up a macro so an option form pops up? allowing selection of "From record" and "to Record" ?
View 13 Replies
View Related
Jan 6, 2007
Im trying to record a macro that will enter a formula in a cell each time I run the macro
Drop the Lowest2:
=IF(ISERROR(AVERAGE((SUM(C5:L5)-MIN(C5:L5)-SMALL(C5:L5,2))/(COUNT(C5:L5)-2))*Scale!$B$2*10),(IF(ISERROR(AVERAGE(C5:L5)*Scale!$B$2*10),"",AVERAGE(C5:L5)*Scale!$B$2*10)),AVERA GE((SUM(C5:L5)-MIN(C5:L5)-SMALL(C5:L5,2))/(COUNT(C5:L5)-2))*Scale!$B$2*10)
Drop Lowest1:
=IF(ISERROR(AVERAGE((SUM(C5:L5)-SMALL(C5:L5,1))/(COUNT(C5:L5)-1))*Scale!$B$2*10),(IF(ISERROR(AVERAGE(C5:L5)*Scale!$B$2*10),"",AVERAGE(C5:L5)*Scale!$B$2*10)),AVERA GE((SUM(C5:L5)-SMALL(C5:L5,1))/(COUNT(C5:L5)-1))*Scale!$B$2*10)
I know I can write the formula in a simpler way, but I was asked to make it like this.
The problem is that when I enter the formula in the cell while recording. I got a message: "Unable to record" so this part can't be recorded
View 14 Replies
View Related
Sep 1, 2009
This problem seemed to revolve around "digital signing" with further macro changes done from a different machine (without the proper certificate). Excel warns of the problem and then "unsigns" the project.
I've got a problem with spreadsheets that I've been working on. Now, when I tell it to record a macro, I get the macro name, shortcut assignment dialog box and then an error "Unable to record." After "Ok"ing that dialog box, the normal recording macro dialog comes up. Also, lo and behold, there will not be a macro recorded.
I've got no protected cells or sheets and it doesn't matter what security level is set. It is a "signed" macro but I can take off the signature and still have the problem. I checked for "Help - About" for deactivated modules and there was none.
View 2 Replies
View Related
Jul 7, 2009
is there a way to stick a few row of cells together so that when i move one they all move.. i have some rows that when i sort them i want them to move together with the other ones..
View 9 Replies
View Related
Dec 14, 2008
Is it possible to add a row between every record, that has different data for 2 columns ( compared to the row below )
View 14 Replies
View Related
Nov 4, 2009
I am building a form that uses a combo box to lookup up a row in a table and return row data. To make things more complicated I want to return more than one record. For example: the table has a list of jersey. I search for a style jersey. I want to search the list and return all the colours for the chosen style. Sometimes there is only one colour or there can be up to 10. Have a look a the attached example.
View 2 Replies
View Related
Jul 10, 2013
How to group different record and name the group. Attached file
View 14 Replies
View Related
Jun 25, 2014
l would like to record a macro that allows one finds a 'key word' in sheet 1 ,then the macro should copy the entire raw of the search results to worksheet 2 .The macro should enable the user to have as many searches as possible but pasting all the results on one worksheet.
View 2 Replies
View Related
Apr 22, 2010
I have designed a website for my uncles business and I have used numerous forms in vba. One of the things he wants me to do is display a list of some of the client details on a new work sheet and I have hit the wall..
I have about 6 worksheets,
The ones i need to access in this instance will be clients.xlsm and the temporary one i have created each time the form is run called temporary.xlsm
I need to search for a particualr client number in row A on the client list and return column number 2 and 3. Usually i would use the match or vlookup function but row A contains the client number numerious times.
However, (this is where I am stuck)
there are multiple client id's in row A. For example the client ID i am searching will exist say 3 - 6 times in row A and i always want to return the row number in a new cell on the temporary page each time it has found it.
I am searching for the client id in worksheet("clients").range("a:a")the client id is repeated and I want to return all the rows if there is a match, but match will only return one row...
would it be a for loop with a match function? -
when I find a match i want to be able to record some of those values on the same row it has found a match on the temporary worksheet
View 9 Replies
View Related
Jul 23, 2009
In some cases an Access DB query will return only one record (by design). When this happens, and only when this happens, my listbox displays each of the values in a seperate row instead of just on one row.
i.e. My query will return 8 values per record. If there is only 1 record returned, the listbox shows each value on a seperate row instead of on one row in 8 columns.
The listbox works as intended when there are 2 or more records. I am now stuck. Pardon the ugly code. "questionaires" is the name of the listbox. "record_array" is the variant array containing the records.
View 4 Replies
View Related
Sep 16, 2005
In sheet1 we have the data
DateTask name Remarks
9/15/2005IncomingOK
9/15/2005OutgoingOK
9/15/2005IncomingNot OK
9/16/2005OutgoingOK
9/16/2005OutgoingOK
9/16/2005IncomingOK
In sheet2 i need data for that particular date of that task only if it is OK
Eg: - on 15 - Sep it should 1 only one record in total if it is OK and task
is Incomig
On 16/sep it should be 2 outging and 1 incoming
View 9 Replies
View Related
Mar 7, 2007
I have a column labeled W-L, In each cell there is a W or an L .How can I total up all the W's and L's and have the total count show a 21-13 (21 wins 13 losses). Also the scores of the games are listed as 5-4, 3-7, for each game.how can I add up all the runs for and runs against to give a total xx-xx
View 9 Replies
View Related
Sep 8, 2008
I have a cell A1 whose value fluctuates.
I need B2 to record the last date of when the value in A1 last went below 0.
View 9 Replies
View Related
Dec 11, 2006
How do we merge changes that were made by two developers, back into one spread sheet? We have a massive spread sheet with 30 work sheets and each work sheet has 5,000 rows. We are in the process of applying budget taxation changes and have two actuarial developers who are updating the same spread sheet. Unfortunately we cannot even separate the work sheets that they touch, as the tax implications flows through most sheets. This means one tax change can impact 10+ work sheets and as much as 150 different rows. In some cases it is only a formula change, but mostly it is also adding new rows and or removing existing rows. Is there any way that we can use a tool to merge these two developers changes into 1 spread sheet?
View 3 Replies
View Related
Mar 20, 2007
The added piece I now need to put in is how many times a cell value is changed in a day (I will add to a macro to return it to 0 at the end of each day). The way in which I would approach this is by using a combination of a cell_change and count function. Could I ask somebody to advise if this is the best way?
View 7 Replies
View Related
Dec 31, 2008
I am formatting a workbook so that the first table is a flat database of information used in other tables in the workbook. Each row in the tables would correspond to the values for a specific year thus,
year|weight|length
1999|24|123
2000|27|134
2001|21|121
2002|25|132
2003|19|112
2004|31|135
2005|22|126
2006|27|145
2007|28|147
I would like to have other tables reference this table and automatically update for the last record in the table so that the second table in the workbook would show,
year|weight|length
2007|28|147
My goal is to be able to go into the first table flat database tomorrow (Jan 1, 2009) and insert,
2008|29|110
in row below the 2007 data and then have the other tables in the workbook automatically update to reflect this new data and show
year|weight|length
2008|29|110
View 11 Replies
View Related
Jan 14, 2009
When I choose to record a macro, the window to name the macro opens and allows me to name it, but when I close it, I can see it is recording at the bottom of the sheet, but the stop button with the relative/absolute button has disappeared. I can't change relative/absolute. How can I get the button back on the page?
View 2 Replies
View Related
May 8, 2009
i'm creating a spreadsheet with records of repair jobs on vehicles that my company is/has performed. the problem is that, the way our system works, there are currently no unique identifiers for jobs, meaning i cannot create a master list with various vlookup tables with only the information relevant for our engineers on them.
is it possible to create a macro or use some other system, that will create a new, unique code when a line/cell is filled in? because we end up sorting the list by different criteria on a regular basis (to find specific jobs) the system can't be relative (i.e. +1 to the code above).
View 4 Replies
View Related
Mar 11, 2013
How does one turn off Relative record?
View 1 Replies
View Related
Apr 21, 2013
how to record a value of a cell whenever F9 is pressed. The cell I want to record the value of is cell D101, which is a sum function of the previous 100 rows. I'd like to figure out a way to run 1,000 trials or so and record the value in cell D101 each time.
Some more details, if needed: I'm simulating a dice game (craps). There are 2 dice, each dice is based off of RANDBETWEEN (1,6) then the dice are added in a different column to achieve the roll. The payout is then based on whatever number was rolled. I'm summing the payout (D101) and would like to run this trial 1,000 times.
View 3 Replies
View Related
Aug 12, 2013
I am trying to set up payment record sheet as follows
First Tab: This is the total value of each item, with the payment date in cell C1
Second Tab: Is the payment date of the item
Third Tab: Is the payment due tab
So what I want to do is enter the payment in C1 on the first tab. Then on the second tab I want to enter all the items that want paying on that day, but this will also have previous payment dates shown as a sort of record of what was paid on what day.
On the third tab I want it to show all the payments that correspond to the same date as C1 DATEVALUE
And on the gross tab I want to show all payments to date including the current date.
I have got the payment date to work but I cant get it to show all the previous values.
View 1 Replies
View Related
Apr 1, 2014
Is there a way to record the mouse movements within VBA. I essentially want to use excel to open an external program and execute specific commands within that program. Unfortunaetly the extrenal program is not a micorsoft program
View 1 Replies
View Related
Apr 22, 2014
Column A | Column B | Column C |
UMB-RPT-01 | 0 | In Review |
UMB-RPT-01 | 0 | Pending Markup |
UMB-RPT-01 | A | Comments - Correct and Resubmit |
UMB-RPT-01 | A | Review Complete |
UMB-RPT-01 | B | Approved |
UMB-RPT-01 | B | Review Complete |
I need to have a macro run through a spreadsheet and look through column a, which is sorted, and then highlight the row that has the latest record. IN the case above it would be 0 with Pending Markup
So the latest value in Column B, whether its alpha or numeric, with a status in Column C of Pending Marking.
View 1 Replies
View Related
