chicago

Good Afternoon, I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great...

I'd like to sum all of the dish sales based on the Location number and Product IDs. Can I do this without creating a helper column? <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Location Product ID Product Desc Sales 2 555652 Houston 10047108 Dish 12" 4 3 555652...

So the easiest way to explain what I am trying to do is with an example. See the sample Data below: <tbody> <tbody> Investment </tbody> <tbody> Current/Prior </tbody> <tbody> Routine/NonRoutine </tbody> <tbody> AA </tbody> <tbody> FHLMC GOLD PL V84191 </tbody>...

I am trying to pull data from one worksheet into another worksheet. I think using Index/Match is the way to go, but I'm not sure how (I tried Vlookup and don't think that's the right formula). Worksheet one has numbers in column A (say 1 to 10), and in Column C has the data (Town visited) I...

Hello All, So I have office locations in sheet 1 as follows: <tbody> Location Address City State Zipcode Chicago 243 W Jackson Chicago IL 60605 New York 505 W 50th St New York NY 10019 Los Angeles 20 Calabasas Road Los Angeles CA 98490 </tbody> Now I m looking to auto populate data...

I am building a workbook as an add-in that will provide specific site information such as address, phone, etc. I'd prefer to not store that data in a sheet, and instead would like to store it in VBA, since it doesn't change. What's the best way to do that? In an ideal world, I'd love to write...

Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...

I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...