how to sum multiple worksheets in a single sheet?

i tried using
=SUM(INDIRECT("'"&$I$1:$J$1&"'!i5"))

where i1 and j1 is the name of the worksheet and i5 is the value present in the all the different worksheets. Now i want that if i will the drag the cell downward and it will show i6,i7,i8 respectively..it should cells ref automatically.

I am looking to perform a series of same function between two cells in an array of cells. I have attached a picture and Excel file to illustrate my problem. Thanks for the help.

I am creating a spreadsheet for a book fair. Each record contains the title of the book, author, ISBN… , book categories, specific interests, relevant school subjects and so on. I used dropdown menus for several fields, like book categories and specific interests. Using VBA code, I allow the user to make multiple selections from many of the dropdowns. The selections are stored as one string.

Here’s the problem:

I need to populate the worksheet below with miles for each route (Row 2) every day (Col. A) from 6 different worksheets.
Excel1.png

I have 6 different worksheets formatted as below. I need to get the miles in Col. I to the correct cells in the worksheet above ("Recorded Daily Mileage") by matching Cols. A and N to Col. A and Row 2 on the above worksheet.
Excel2.png

I believe this is possible using MATCH INDEX, but not sure... Can someone please point me in the right direction? I don't need explicit instructions, just need to spend time on something that I know can work...

Hello,

I am having problems writing a code to copy the rows from one worksheet to another, if certain criteria are met.

A data dump is taken from a report and copied into worksheet "a" (starting at C5 due to column headings etc), then in worksheet "b" I need to, on the pressing of a command button, delete the current data in worksheet "b" (C5:Z21000), and pull through data from worksheet "a" (C5:Z21000) if the code number in Column P ends with a ".99" (example code: AB.CD.01.99) and if Column S is NOT populated.

If I have a cell that I want to take total from another cell but cap it at 8 so anything greater than 8 shows as 8. How do I do this? tried this but no workie: =AU36,IF(AU36>8,"8")

Hi, I am a novice excel user.

I am trying to set up a master document containing multiple worksheets where for each worksheet a separate workbook is created and is updated each time the master is updated.

For Example

Master Workbook contains 4 worksheets (Site1, Site2, Site3, Site4).
Then I split the Workbook ending up with 5 document files in total (Master, Site1, Site2, Site3, Site4).
Then I create a shortcut / link the Site1 worksheet in Master to the file Site1 and whenever an update is made in either the master file or the Site1 file.

Hi,

I have almost 50 to 60 pictures imported. ButI would like to add only its filename on cell B to properly identify it.

Could you please help

How can I list bookmarks from a adobe pdf file to a Excel sheet?

Hi ,
I want a if formula for the below

Where in I have to classify the maturity dates as below.

If a date is less than 2 weeks from today then it should reflect as BUCKET C
If a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET D
If a date is more than 1 month and less than 3 months then it should reflect as BUCKET E
If a date is more than 3month and less than 6months then it should reflect as BUCKET F
If a date is more than 6month and less than 1year then it should reflect as BUCKET G

Hi there every one. I have built a mini CRM type spreadsheet to track very specific client appointment centered information. I also built a couple of summary pages that I want to have calculate some reporting numbers for me based on the information.

Hello! I need urgent help with a task from my working place. I have a list with data to modify in other bigger list, using a stamp. I need "something" to find data from a source table in other bigger table, and when data is found, in a certain column to insert a value. More exactly, a have two sheets and in the second sheet is data to find in the mail table situated in sheet 1. When the data is found in sheet1, where the main table is, a stamp must be inserted.
Thanks a lot!

I have a userform with more than 100 textboxes. Although fairly new to VBA, I know how to add ON ERROR code to a textbox to handle errors. My questions is whether it is possible to put this code in some central place in the userform/module/etc such that any error in ANY textbox can access it -- that way i will not have to put the code in EACH textbox.

For example, I would put something like ON ERROR GOTO "this routine" in EACH textbox's code

Then, somewhere centrally located (NOT in the TextBox) would be "this routine".

is this possible? If so, how?

I have created a spreadsheet and a few user forms in Excel/VBA. Having a hard time linking the userform to the spreadsheet. I can open thru a commandbox on the sheet to enter a new item, tab thru/enter the information, but the add item button will not connect, the cancel/exit however, does. Also help with the second button that I cannot find how to search by cell. thanks!!

So basically I have trawled a million groups trying to find an answer to my problem but couldn't and so was wonderin if anyone here could assist.

I have 2 spreadsheets called "source" and "input".

"Source" contains rows of data, each one has a unique identifier.

You can input this identifier in to "Input" and it reads "Source" using traditional Index Match codes based on this.

I am a secretary of a new club. I posted everyone who has joined over the year. It time for them to renew there membership.
How can I have excel find them for me. I am sure it is quit simple
Excel 2003 Windows 7
Thank you for your help

Hi everyone I'm looking for a way to do some merging a very specific way. I've tried looking for a way to do this and everything that I've found is a little different that what I'm trying to do. At this point I'm at information overload and so I need some help to do this. In my mind doing this should be easy, but I just don't know "how" to do it.

So anyway, I'm looking for a way to merge columns from two different spreadsheets while merging the information to its respective row (case#).

Here is the scenario:

The current VBA macro works like this there is data in five columns what ever data that is not colored will be used to run combinations from each column from left to right.

currently when ALT f8 is depressed a box appears in which I would put the ABCDE which is the order into which the data is pulled from left to right. so it looks at the data in the columns EFGHI.

Hi Excel Lover,

you may get the complete shortcut keys for Microsoft Excel 2016. hope you like it.

http://successentrepreneurship.com/index.php/2016/02/24/these-microsoft-...

Hello,

I have the following table:
Name Dates
Student1 2.2.2016 5.2.2016 18.2.2016
Student2 5.2.2016 6.2.2016 8.2.2016 16.2.2016 29.2.2016
Student3 4.2.2016 6.2.2016 16.2.2016 18.2.2016
etc.

I`m searching for a way to find who attended an a particular day i enter. for example:
date i enter: 6.2.2016
result generated:
Student2
Student3
etc.

Is it possible to do this in excel?

Thank you

I have mentioned requirement in the attached sheet itself. please help as early as possible.

Hi,
Is solver capable of optimising a transport network where all nodes can be source nodes, destination nodes and transshipment nodes?

My transport network has multiple depots of which all act as sources of freight, destinations of freight and on-forwarding hubs.

Any help is appreciated.

Kind Regards,
Adam

Hi there,

Sorry if this has been asked previously but I have done a lot of searching online and not been able to find a suitable solution. I have had no excel training and a very basic user and would really appreciate your help!

I am trying to automate a very tedious task.

Basically I need Excel to find the first cell of a specific colour that is not in the index but it have the hex code and RGB value (32CD32 & 50,205,50) and once it has found it to return the column header.

I want to build multiple pivot tables and update all pivot tables on a monthly basis.

The pivot table is built showing a summarized metric for several marketing campaigns over time. The pivot table will show the month as a column lable, the campaign as a row label, and the metric as the value. An example of the data would be something like the following:

Camp1: M1, 1000, M2, 850, M3, 2000
Camp2: M1, 1250, M3, 2500, M4 1750

hello friends,

was struggling with an excel formula and finally found this site after googling. Hope to get help here.

i need to identify the number of transactions instead of number of equipment based on the column B.
For example, from rows 8 to 10, i want a formula at Col H to indicate that it is ONE entity instead of THREE based on the condition of Row B and Row C having the same data. An unique running number will be cool too :-)

Is their a formula you can use to calculate trends?

I have the following code in my spreadsheet to allow for multiple selections in all drop down lists. I need to protect the sheet and keep the functionality of this code. I know I can add a couple of lines to make it work; however, I an in no way a programmer. Can you help me?

Dim Oldvalue As String
Dim Newvalue As String

Application.EnableEvents = True
On Error GoTo Exitsub
If Target.Address = "$C$10" Or Target.Address = "$C$16" Or Target.Address = "$C$17" Or Target.Address = "$C$19" Then

If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then
GoTo Exitsub

Hi. When I format a number with currency symbol, I get a drop-down list with currency symbols.
How can I change the order of this list? For example, I want RUSSIAN currency to be first in the list.

Thank you
Alex

I have mentioned requirement in the attached sheet itself. please help as early as possible.

I honestly don't have any idea what I'm doing. The most I have ever done in Excel was to fill in a previously-written form for expense accounts, several years ago. It was basic, and had few functions other than adding up small expenditures, and removing that amount from the overall balance.