Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Petty Cash Spreadsheet


i am trying to set up a spreadsheet for petty cash so will have a description and an amount on the left of screen and numerous columns on the right for the transactions to be split between ...... Is there any way for me to tell it that if A2=fuel truck then the amount in column B2 needs to also be in column G2?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Building A Cash Register
I want to build a cash register from excel.

I want to put many buttons, but lets say one on A1 that says $2 dollar item and name and lets say this $2 doillar item button is pushed(clicked on), it will add $2 to lets say the total say A15.

Now I can't even get a Macro to add $2 dollars to A15(or any macros to run at all, anybody have code I can copy, what I understand is you create macro name(give it letter, so yo can press letter and Ctrl to start) then start recording, then you do key strokes or mouse? Then press stop recording and you have macro?).

To get buttons to be viewed I have to go to Tools - Macros - script editor, and drag and drop(button on coding) or double click on button tool bar then File - View in Browser - . I get button but can't get it to do anything.

How do you put say A1 in code to A1=A1+5 or make a memory location out of A1. Now you can go to(while A1 is selected cell) "Insert" then "Name" then "Define" and give A1 a "Name". I can't get this name to work in coding(but I can get the name to work in cells like "Name" +5, will add cell 1 and 5, if you do it in different cell than A1).

View Replies!   View Related
Filter For CASH NOMS And Keep Everything Thats In The Criteria
i have rec data in which I need a macro that will filter for CASH NOMS and keep everything thats in the criteria but delete everthing else in cash Noms

criteria is named range "Criteria" (I5:K10)

So from this

Sheet1 ABCDEFGHIJKL4Criteria5RecTeamAmountRefRecTeamRef6CASH NOMSAMP1132.36CAETRNCASH NOMS*AMP*.AIMS7CASH NOMSAMP215.36.AIMS546.3*WTRN968CASH NOMSINTEREST915.12WTRN96*AMPTRH9CASH NOMSFA5-65.36AMPTRH*.WSTFGH10CASH NOMSFA6-9.01CBWSSG*WTWHAT11CASH NOMSCA-9.01CBWSSG12CASH NOMSDES-9.01MSFAST13CASH LIFEUUTU-9.01CBWSSG14CASH LIFEAMP1-9.01CBWSSG15CASH LIFEAMP232.12.WSTFGH16CASH LIFEAMP315975.36CBWSSG17CASH LIFEAMP4-9.01OPTMOD18CASH NOMSFA1-9.01CASH WTWHAT Excel tables to the web >> Excel Jeanie HTML 4 .........................

View Replies!   View Related
Cash Flow Distribution Modeling
I am trying to model the distribution of cash flows from a real estate investment. This is a bit complicated, but basically A1 through A37 are a series of cash flows after payment of debt service from month 0 (closing) to month 36. The real estate project has two investors, the Institutional Investor and the Developer. In this case, the Institutional Investor contributes 90% of the required project equity and the developer contributes the remaining 10%. The cash flow is distributed according to a set of parameters specifying cash flow percentage allocations and IRR targets, collectively known as a "cash flow waterfall"." As with all for-sale residential development deals, the early cash flows are negative and then turn positive as unit sales occur. The order of distribution of the cash flow remaining after debt service is paid is as follows (the waterfall):

1. Both investors receive the return of their invested capital from cash flow distributions.
1. Hurdle 1 (after the return of equity to both investors), the Institutional Investor receives 90% of the monthly cash flows and the Developer 10%, proportional to their respective overall equity contributions, until both investors achieve a 12% IRR (all IRR's to be calculated from deal inception/first dollar invested).
2. Hurdle 2, (after Hurdle 1 is satisfied), the Institutional Investor receives 60% of the monthly cash flows until the Institutional Investor achieves an 18% IRR.
3. The Final Split (after satisfying Hurdle 2) allocates monthly cash flow 50% to each investor.

On an overall project basis, the Developer should realize a disproportionate share of the cash flow after the second hurdle is hit. This is what is known as the "promote." The most recent 36 month (37 including Closing) projected cash flows are as follows:

($1,315,567) - Closing
($113,697) - Month 1
($178,397)
($168,667)
($150,365)
($36,506)
$16,662
$120,283
$107,443
$107,443

I realize this is complicated, but this structure is quite common to real estate, private equity, venture capital and hedge fund investments (along with most any joint venture deals with multiple classes of equity participants). The canned software that is out there that performs this type of anlysis is both expensive and rigid, and doesn't typically enable the required sensitivity analysis in structuring a deal.

View Replies!   View Related
Debug Selection & Cash Register
I'm working on a sheet where I can specify sales by selection of month (Sheetname= ZoekenMaand).

Everything works fine for the months "januari" and "februari" (yes, it's in dutch ) but from "maart" it doesn't seem to work any more.

View Replies!   View Related
VBA Code To Open A Cash Drawer!!!
I have Created an Excel Spreadsheet to work as a EPOS system. The only Problem i am having finishing it off is getting the cash Drawer to open at the end of a sale.

I have my Cash Drawer connected via a Rj 45 in the Back of my Receipt Printer. The Printer i have is a Star Tsp-600. I have Found out that the Open Drawer Codes are 7 or 27,7,10,50,7. I am not entirly sure what they mean though. The code that i have at the moment doesnt work it brings an error "53" file not found. This is my code

View Replies!   View Related
Offset Function For Cash Flows In Different Years
I have got three period like this

Period: 2010 2015 2018
Cash: 100 200 300

I would like to use a function (i am thinking offset will do the work) to put these cashflows on a timeline i.e. 2010,2011,2012 etc...

The three periods described above will be changeable, so the cashflows will adjust accordingly...

View Replies!   View Related
Cash Register With Keyboard Numerical Keypad
With reference to Cash Register example that I downloaded from Roy Cox; is it possible to link the numerical keypad that is created in the file to the PC Keypad.
I realise I would need to use keypress functions but am unaware of the ascii for these keys. Also; how do I limit that the keypad writes it to the label? Otherwise, would I need to create a new userform instead of what was created by Roy.

View Replies!   View Related
Projection Spread Sheet For Cash Flow Purposes
I am trying to put together a projection spread sheet for a client for cash flow purposes. I have it laid out but I cannot wrap my head around the formula and I've tried a few. Here it is.

A1: Client Name B1: Invoice Date C1: Projected Due Date ( I have 45 days added to B1) D1: Invoice Amount E1: Jan F1: Feb G1: March H1: April I1: May J1: Juneetc...

I am trying to forcast out the invoice collection date (C1). So basically in the month of June column I am trying to say if C1 falls between June 1 & June 30th then it should equal D1 (the amount due in that month). So if the invoice has a due date (C1) that falls in that particular month than I am forecasting the cash flow in the month it's collected.

View Replies!   View Related
Payback & Discounted Formulas For Uneven Cash Flows
formula in excel to calculate payback and discounted payback periods with uneven cash flows.

EX.
Yr CF
0 ($2,000)
1 160
2 200
3 350
4 395
5 432
6 440
7 442
8 444

View Replies!   View Related
Spreadsheet That I Have A Lot Of Macros That Are Attached To A Customized Toolbar Saved In The Same Spreadsheet
I have a spreadsheet that I have a lot of macros that are attached to a customized toolbar saved in the same spreadsheet. I saved this is a read-only file. When I open as read-only and run my macros (testing), I save it as another file. When I then open the "template" to do the same thing, the toolbar/buttons now reference the file I previously saved as something else. Help please? Is there a macro that would delete all macros before saving the file as something else?

View Replies!   View Related
Merge Files? (add Data From One Spreadsheet To The Appropriate Places On Another Spreadsheet)
Often I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:

Sheet A has 10,000 records with these fields: id#, name, address, place of employment.

Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.

Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.

View Replies!   View Related
Multi-Spreadsheet Formula Down To Populate The Other Cells In The Total Spreadsheet
I have attached a document paralleling a document I am working on. The dollar amount in each spreadsheet represent sales. I have entered in values into the candy, soda, and chips spreadsheet. I have also linked values for candy into the total spreadsheet. My question is can I somehow type something or drag the formula down to populate the other cells in the total spreadsheet?

The idea I am thinking but which I don't know how to implement is to list all the items (as in column G) and list all of the relevant cells (e.g. B1 in the Candy spreadsheet) as in columns H and I (Note that all items will have the same cells but the cells will have different values...e.g. all three items have a cell B1 and B2 in their spreadsheet but these cells contain different values). I then try and fail to create a formula in cell B3 of the Total spreadsheet. I am trying to create a formula of the following nature:

='(Spreadsheet Name From Column G)'!(Cell Name From Columns H and I)

The Second half of the formula doesn't really concern me (i.e. the cell name from column H and I). However I am perplexed as to how to achieve the goal in the first parentheses above.

View Replies!   View Related
Copy Certain Cells From 1 Spreadsheet To Other Spreadsheet Depending On Condition
I have noticed that the basic problem I have is a common one on this forum with different varibles for different people. I have attached a dummy copy of the spreadsheet that I am using.

I need to copy cell information for one spreadsheet to one of 2 other spreadsheets depending on a dropbox condition. The master spreadsheet is the Issues spreadsheet, and depending on whether the user chooses Transferred Complaints or Transferred Offences (in Column K) I need to transfer certain cells to the Complaints or Offences spreadsheets.

The information I need to transfer from Issues is: .....

View Replies!   View Related
Spreadsheet To Note Book And Back To Spreadsheet
It also renames the CommanBarPopop with the new filename.This allows the user to open both Projectworkbooks/files (If required) and load each CommandBarPopup for different filenames .Therefor opening the Userforms and worksheets for the CommandBarPopup clicked ...

View Replies!   View Related
Importing Data From Spreadsheet To Spreadsheet
I need to write a macro that will import data contained in another spreadsheet, but am unsure how to do this. I have several (about 15) spreadsheets that contain data. I need to import key bits of this data into one central spreadsheet that will be used for reporting purposes. I only need 2 cells worth (values) from each source spreadsheet, to be pasted into the destination spreadsheet, into designated cells.

The source spreadsheets are usually closed down and kept on a file server, which my PC has access to. Ideally I want to activate this macro with a control button - i.e. I press the button once and the macro goes off and collects/updates each field with the latest data stored in each of the source spreadsheets.

View Replies!   View Related
Open Second Spreadsheet Minimized On Open Of Spreadsheet + More
I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.

On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.

This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.

View Replies!   View Related
Recognize #N/A In Spreadsheet
I am trying to write a macro for excel, deleting columns of #N/A generated in a text file. I'm having a hard time identifying the #N/A in the cell. I've tried

If Cell.Value = "#N/A" and tried if IsError("A1").


View Replies!   View Related
Get Info From One Spreadsheet To Another
I want to be able to connect two spreedsheets.

I have a "surplus inventory" sheet and a "inventory shipped" sheet. How can I input how much I shipped in the "inventory shipped" sheet and make it take away from my "surplus inventory" sheet automatiaclly?


View Replies!   View Related
Spreadsheet Do Not Change The Old Value
I have a row of cells named B1 and B2.

Today I want the value in B1 to be the product of A1 times A2.

Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.

I do not want the old value in B1 to change from what it is today.


View Replies!   View Related
Slow Spreadsheet
My spreadsheet is chugging through the following code. The data being filtered is rows A:AC, rows 10:193 (so not an absurdly large amount of data). It takes about 15 seconds to complete the filter. Ideas?

Private Sub EuropeButton_Click()
HeaderRegion = "Europe"
ActiveSheet.AutoFilterMode = False
Range("A2:A8").Value = 0
Range("A2").Value = "TEG"
Range("A3").Value = "TUK"
Range("A4").Value = "TEF"
Range("A10").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("A1:A4"), Unique:=False
If Columns("E:F").Hidden = True Then
Columns("E:F").Hidden = False
End If
End Sub

View Replies!   View Related
Text (spreadsheet)
In certain cells of a spreadsheet I have long text entered but it shows a series of hash signs instead.

View Replies!   View Related
Output From Sub To Spreadsheet
I have a function which either looks up a value on a spreadsheet or runs a sub. If it runs the sub, it should generate a list of figures which are output to a spreadsheet.

My function keeps crashing but I have found by stepping through it that is correctly decides whether to lookup a value or run the sub. It starts the sub correctly but when it comes to outputting information to the spreadsheet it crashes. I have lx_calc set as an array and I am using the following to output to a spreadsheet (lx_calc(20) is defined as 10000 and ImpFac and qx have already been calculated):

For i = 21 To 120
lx_calc(i) = lx_calc(i - 1) * (1 - (1 - ImpFac(i - 1)) * qx(i - 21))
Workbooks("Macro Ann Addin.xls").Worksheets("Mbr").Cells(i + 1, 1) = lx_calc(i)
Next

I can't see why this doesn't work unless it is just that it doesn't like the fact it is looking at an array.


View Replies!   View Related
Spreadsheet Search
I have a spreadsheet with 28 sheets and I want to be able to list out a string on each sheet (eg search for the vakue of MPP** on each sheet).

The information I need is in column B and I wold need an output showing the search string and the sheet name. Please note there are multiple instances of the search string on each sheet.


View Replies!   View Related
Cricket Spreadsheet
I am trying to set up a cricket spreadsheet

I cannot work out how to set up the 'Overs Bowled' column.

I somehow need Excel to recognise a figure in another format other than decimal.

There are six balls in an over so when I enter '5.5', this means 'five overs and five balls' rather than '5 and a half overs'.

View Replies!   View Related
Function- Spreadsheet
I have a spreadsheet that looks like this:

A B C
### ###
### ###
### ###

I am trying to figure out a function to find the median of Column B of the ones that have a column C greater than 1.

I need (some how) to filter out the column C that are greater than 1 and then take the median of those left.

View Replies!   View Related
League Spreadsheet
We have an archery league that is getting very popular, and very time consuming. We have a spreadsheet now that works, but so much of it isn't annomated that it's not saving a bunch of time for us. It is, however, very accurate, so we keep using it, but I think there is a better way out there to do it, and I bet one you excel pro's know the answer.

Here is how it works:

We have three man teams. Let's say we have 20 teams again this year (we did last year). These teams will have their own unique schedules of other teams that they will play against. We have ten weeks of head to head team matches.

Every week, every shooter's average is computed. So, week one their average is whatever they shot. Week two is the average of week 1 and week 2 combined, and so on. This revolving average keeps shooters from sand bagging.

The team head to head match ups are handicapped. Let's say that team 1 is up again team 2 in week 1:

Team 1 is consisted of bill, bob, and barry. Bill's average at this time is 300, bob's is 290, and barry's is 295.

Team 2 is Larry, Leonard, and Louie. Their averages at this point are 290, 280, 300.

The head to head team match up is consisted of three individual head to head's. The shooters with the best averages, at this point in time, face off, the middle averages face off, then the lowest average shooters on each team also face off. You get 2 points for winning your head to head match. You get 1 point for tieing. Zero points for losing.

The handicaps kick in like this. Bill is the high average shooter on Team 1. He faces Louie since Louie is high man on Team 2. Since their averages are both the same, this match is a head's up, scratch, match with neither shooter getting spotted points.

The middle shooters are Barry with his 295 against Larry with his 290. We use a 80% handicap. So, Larry gets "spotted" 80% of 5 points, or 4 points. The same goes for the matchup of Bob against Leonard. Leonard gets 8 points in his match (80% of the ten points that his average is lower).

Shooters shoot their games, scores are taken, points are spotted points are added in, then winners are declared. Then, the points each shooter wins is added into a team total for that week, then on to the next week's match.

My biggest problem is that the #1, #2, and #3 shooter on each team, each week, changes sometimes. In my previous example, lets say that in week two, lets say louie blows it and shoots a 270. So now his average isn't the highest on his team, so the pecking order of the team changes.

So, my challenge to this board, if you wish to accept it, is how do I set this bad boy up? Lots of issues here. The biggest one is how to get the teams to self rank themselves each week?

I'd love to have a tab where I enter each shooter's score in, and excel takes it from there giving points to winners of adjusted matches.

View Replies!   View Related
Search For Name Within Spreadsheet
I am looking to have a front page in my workbook which has the function to search for a name with in the workbook. the Tab will be named after a person and on searching, i would like the tab(worksheet) to appear.


View Replies!   View Related
Data From Another Spreadsheet
I have a spreadsheet with approx 60,000 lines and 14 columns. Col N is month (June to July).

In another spreadsheet, I want to return the data for a specific month. Is this possible?

View Replies!   View Related
Spreadsheet Naming
We utilize a shared spreadsheet in our department named "Arrangement Requests".
From time to time and seemingly very random the sheet renames itself. When this happens anyone adding information to it becomes unable to save since the original "no longer exists".

This causes problems because everything we do is in real time and expected to be viewed by all as soon as save has been indicated.


View Replies!   View Related
Warehouse Spreadsheet
I have a 1046 line spreadsheet that I need to enter 8 additional lines after each current line. I would like to do this for the entire spreadsheet at one time. I also need to lable each of the 8 lines from the name of the org. line. For example, the org. line product name is 1234 and I need to lable the 8 additional lines under that product 1234-A, 1234-B, 1234-C, etc..

View Replies!   View Related
To Formulate The Spreadsheet
I have managed to formulate the spreadsheet so that it looks up to exchange rates for particular days automatically, but I am now trying to make a macro which allows users to insert a new expense into the form.

I require the macro to move a selection labelled TOTALS down a row, and then copy the formulae from other rows down to the new row below. That's not particularly well explained.

Basically i have one row which is formatted correctly with formulae etc, and i want when the user clicks the macro button for the totals (which are two lines beneath) to be moved down a row, and the formatted row with formulae to be copied to the next row below. The important formulae in cells have labels attached so if i can use these it may be easier?

View Replies!   View Related
Spreadsheet Compilation
Would anybody have a copy of Visual Baler kicking around that could get me a copy as the company that developed is has been long defunct and the former owner since has gone the was of its predecessor.

View Replies!   View Related
Compare The Spreadsheet.
I have tried google, but not 100% sure of exactly what i am looking for, well how to describe it to google at least.

I have 2 spreadsheets for an online store, 1 is the CSV update with all active store products on it, the other is the suppliers main price list.

What i am trying to do is get some application or macro code to compare teh 2 sheets.

Update File has 4 fields, SKU, Product Name, Price, and Availability.

Suppliers sheet has many more Starting with SKU, Price incl, Price excl., Product Name and Descriptions.

What i would like to do i have is compare the SKU and Price inlc between the sheets and the if differences are found update it on the csv file.

The supplier sheet also has separations for different product categories on the 1 page, totalling about 60 000 rows. The separation rows just break the product areas and are not merged do the resulting scrip or application would need to search and replace not just flow down the column.

View Replies!   View Related
Emailing Spreadsheet ...
Does any want know how to do the following:

1. In the same Workbook, I have one sheet with email addresses.
2. On Sheet 1, in Cell D3, I have the actual email address I want to send(Used data validation drop-down to get email address)
3. Ive used many codes and it sends very well, however it does not send the email as a fully functioning workbook.
4. The recipient gets the following message "This book contains links to other sources"

View Replies!   View Related
Highlight If Same Value Is In Spreadsheet
i have a spreadsheet with loads of info.

In this info, should include something i have produced.

So the best way to check is by reference number.

So my spreadsheet has a column with references.

So lets say from A2 downwards, i have data like (But 1000's more)

344
5345
5345
34556
63321
36567
32214
5223
2142
2344

Now, the data below produced from a different speadsheet, should be in the above

344
5345
5345
34556
63321
36567
32114

Whats the best way of doing this?

I have put both sets of data in the same spreadsheet, with the second lot below the first lot.

View Replies!   View Related
Spreadsheet Formula
I am creating a spreadsheet and have run into a brick wall. Row 1 contains a list of dates Mon-Fri as far out as I could go. Rows 4, 5, 6, and 7 contain a code. Using those, I want to figure out an if statement that will place a 1 in the cell if the date in row 1 falls between a start and finish date. The data sheet looks like this:

A2- Code
K2- Start Date
L2- End Date

This is the formula I tried, but it does not work completely for me:

=IF(AND(K$1>=Data!$K$2:$K$1000,K$1

View Replies!   View Related
POKER SPREADSHEET
writing a spreadsheet that interprets poker hands. I've finished, and it works. I have successfully dealt "Texas Hold Em" poker to 10 players, dealt 5 community cards, and then interpreted the best poker hand and declared a winner.

I did it by using separate tables testing whether certain poker hands existed or not, and I used completely intrinsic Excel functions, NO VBA. That's for those of you who said it couldn't be done! I may soon introduce VBA to slow down the calculations using buttons, and simple things, but Excel can do this.

View Replies!   View Related
Spreadsheet Links
I've created a spreadsheet which pulls data from about 5 other spreadsheets via links in the formula.

Unfortunately I am having trouble with these updating. I have to open the 5 individual spreadsheets in order for the data to pull across otherwise I get VALUE in every cell in the amalgamated spreadsheet.

Any thoughts why this should be the case? I've tried it in the past and it's always worked fine.

View Replies!   View Related
Spreadsheet Sorting..
I'm trying to sort this spread sheet so that each email address will have its own column assigned to it. Ie jaz@hello.com will alway be column C and harry@hello.com will always be in D. The problem is I've around 1200 rows of infor and the email addresses are all over the place..

View Replies!   View Related
Opens Spreadsheet Twice
When I double click an excel spreadsheet in windows explorer it opens spreadsheet then closes it then opens it again.

This doesnt happen if I have an instance of excel already running.

I thought it might be to do with file association and the open with option.

View Replies!   View Related
Print A Spreadsheet.
I wanna print a spreadsheet. but i want the first 5 columns to be the header on every page.

View Replies!   View Related
Spreadsheet Uses At Work
The spreadsheet has been around for a long time. Even in the electronic form, it has been around for over a quarter century. How has the electronic spreadsheet improved or changed your job?

I'm taking a course in computer applications and will be using any information I get in replies to this thread in my term paper.

View Replies!   View Related
Emailing A Spreadsheet
I have a spreadsheet that I email daily after I update the information in it.
I was unable to find a "Code" to do so when I wrote it so what I did instead is use the Sendkeys funtion to emulate the keystrokes as if I were doing it manually. This works well with one exception.

I now have 5 email accounts and I do NOT want it to email via the default. I need to SPECIFY wich account to email thru. But I can ot figure out how to do this.

Sub Email()
' EMAIL Macro

ActiveWorkbook.Save

Application.DisplayAlerts = False
Windows("Load List.xls").Activate
Sheets("email").Visible = True
Sheets("email").Select
Range("a1").Select
SendKeys ("%f")
SendKeys ("d")
SendKeys ("m")
Application.DisplayAlerts = True
ThisWorkbook. Saved = True

View Replies!   View Related
How To Setup A Spreadsheet
I am trying to set up a costings sheet for my other half. So far I have worked out his costs for this basics i.e. van etc. man power, days, mileage. He now wants to be able to enter his miles to a job, man power, days etc, Then to show total invoice cost and show profit i.e. if miles need to be changed.

View Replies!   View Related
Dates In Spreadsheet Changed
the dates in my spreadsheet changed from dd-mm-yyyy to a random 5 digit number. For instance, if I enter in 01-07-2007, it will re format to to 39089. I am trying to fix it, but I can't seem to figure out what happened and how to get all of the dates back to normal. Is there a way to fix this?

View Replies!   View Related
Reset A Spreadsheet With A Macro
As mentioned I want to create a button that can reset this/a spreadsheet.

DWOR_2.zip

I have locked all the cells and unlocked the cells with the light green background. I.e. where a user can input data.

I haven't added a password yet nor protected the sheet. (the macro needs to work when the sheet is protected.)

I am looking for a macro that can be used to reset the sheet to its original state. However, the sheet needs to be protected.


View Replies!   View Related
Pulling Information From A Spreadsheet
Hi folks, I got great help just now on the first part of this project and am hoping to get lucky again. I attached a workbook. This is traffic count data. I need help pulling information from spreadsheet named HourTotals.

The data is in cells H2:AE366, it is 24 hours wide by 360 days long. I need to search that range for the highest number and in addition to the number get the corresponding date from the date_ column and the hour from the corresponding hr_X column and paste that information into another spreadsheet and repeat that process for say 500 values.

View Replies!   View Related
Sync Data From One Spreadsheet To Another
I created a 10 spreadsheets for 10 companies that include 25 columns of info each and multiple tabs.

I need to create a master spreadsheet, which contains info from all 10 companies but only 10 of the columns are necessary. I want to ensure that if a change is made in the master spreadsheet in one of the columns for company "A", that change is reflected in their personal spreadsheet as well, pretty much syncing info typed in one worksheet to a spot in another.

Is that possible?

View Replies!   View Related
Spreadsheet Control With Range
Hi all im having a tough time trying to figure out a way to select a range (which will be the entire row )based on a condition that will be data selected from a combobox and display that range in a userform with spreadsheet contol 9

what i have so far is a worksheet with all the data.
i have a combobox on a userform that is prefilled with data from a specific column

every thing is working except when i select the entire row how do i change that to a range that i can use in the spreadsheet control 9 that is added to the userform.

View Replies!   View Related
Soccer Statistics Spreadsheet
Back to test you with a few problems as I work through a project I'm carrying out, based on past results data of the English Premier League.

I have some of the solutions/formulas I require already, but there are still some gaps to be filled in!

***

the spreadsheet is set out as follows:

Key Columns / Sub-Title (Remarks)

B Date (the date a match was played - the s.sheet is sorted by this column, A>Z)
C Home Team
D Away Team
E Home team goals scored
F Away team goals scored
I-M Indicates via U or O whether the match contained under or over 0.5,1.5,2.5,3.5,4.5 goals
N Points obtained for Home team (i.e. 3 for a win, 1 for a draw, and 0 for a loss)
O Points obtained for Away team (i.e. 3 for a win, 1 for a draw, and 0 for a loss)

There are 381 rows in total for each worksheet (season) - 1 for the titles, and 2-381 for each match played in the season...................


View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved