I work for a nonprofit and I'm trying to create a report for outreach. I need to know the type of outreach done and topics covered at the event,then tally up attendance per outreach type and by topic covered.
I divided it by week, and where I'm stuck is trying to figure out the grand totals for the whole workbook.

any help would be highly appreciate.

thanks,

Hi,

I am creating a rota and can create a VLOOKUP successfully to see how many hours each shift contains, however I need this to actioned for a weeks worth of shifts e.g. Monday 12:00-18:00 is 6, Tuesday 10:00-16:00 is 6, Friday 18:00-22:00 is 4.
I have the rota showing the shift times and want the total box to show the total number of hours for this weeks worth of shifts.
Can anyone help? Lehmans terms preferable please as I have searched Google but can't make sense of some of their explanations :)

Hi Guy

I really need your help please.

My Excel knowledge is very limited if it comes to this.

I have data in a sheet which we currently manually capture in another system

The data however is in the wrong format for bulk uploading.

Below a link to an example.

The Data sheet is the format we currently use. The Cliam sheet is the format it needs to be converted to.

I am goint to try and explain it to the best of my ability.

Hello,

I'm currently developing several Dashboards using an add-in to extract data from web services (such as Google Analytics). Given some of these webservices dont give the opportunity to make webQuery, I'd like to know if any1 could answer to this unsolved question:

- May I integrate an add-in (request) in Macro? If yes, how would it be possible to develop this macro?

Please, I'm looking for this answer for several weeks already. So if you have any clue, feel free to share :)

Thanks

KR,
Théry

Hi,

I have been following all your posts on your youtube.

Just recently, I have learned how to extract records with multipole criteria’s dynamically. However, I still don’t know how to extract records when one of the criterias cells is blank

For example, if I am extracting using 4 criterias, (date-sales-region-salesman). For this, I have created 4 dropdown cells.

What I need to do is to leave the salesman cell blank, but still extract the rows that matches the 3 other criterias data-sales-region

Many Thanks,
Saud

I need to be able to add cell "2" plus cell "4" in column A, to equal 28% (fixed amount) in cell 4, column B. Does anyone know a formula for this?

So, let me explain my scenario...

I have 4 workbooks with employee's times listed for every day of the week. I have a master workbook that has worksheets that divide the employees up. Each worksheet in the master has a total of 6 potential jobs that could have been worked on (yes, per employee which is the worksheet).

I want to find a way to check the contents of each "workbook" and place in the corresponding master sheet's worksheets (or employees sheet).

The key field is:

Employee

I am trying to figure out how to configure a formula (I believe it will be a combination of MATCH and VLOOKUP) to get results out of the following chart. The difficult part about the formula is that it will have three drop downs:

County
Persons
Percentage

Between these three options, I want Excel to return the corresponding cell.

Hi everybody,

I have request to you. I have a lot of Excel files in my company, and it's a mess. It's really hard to manage all of those spreadsheets and know how other use them. I think about excel extension which could track all excel files in my company i.e it could see which files employees use regularly or which ones are unused. How many times I open files and for how long I use them. How big and complex are my spreadsheets. What do you think about it? Have you ever heard about something like that?

Can somebody help me ....................

I need help - to prepare monthly report out of weekly reports sent

Thanks in advance

Hello!
I am a novice with Excel and need to extract multiple rows from 5 different sheets to one sheet based on certain criteria. Additional data is being entered into the 5 sheets regularly, so I need the solution to auto-populate(dynamic?). I am using Excel 2013, on Windows 7. I have never used anything other than formulas in my spreadsheets.

Here are some more details:

Hello,

I am trying to calculate what the interest rate would need to be after following a shorter term essentially cost the same as as a longer term.

My example is;

$100,000 Principal & Interest over 25 years comparing a 2 year rate 5.00%apr vs a 3 year rate 5.20%apr.
I want to work out what the 1 year rate following the 2 year rate would need to be to break even with the 3 year rate.

Thus far I have been able to compare the CUMIPMT and CUMPRINC formulas of the known rates.

 for all the unique values in "A" if all the corresponding values in "D" are "none issued" then give me "Action" otherwise "cannot action

Hello,

I am self-taught in VBA so my knowledge is limited. I figured out how to merge multiple files together and insert a column, but am unsure how to make Column A be the file name (I need this to be an identifier for the data).

I also receive a pop up that says "A formula or sheet you want to move or copy contains the name '...', which already exists on the destination worksheet. Do you want to use this version name?" How do I code this to select "Yes" each time?

What I have is below:

Sub simpleXlsMerger()
Dim bookList As Workbook

Hi Everyone

hey. can someone help me with a macro something , I have a file with more varinte of those variants want to know who were often together.

I have some formulas in the file , but I am looking to take a lot of time manually , CF- CM cells are options that I 'm looking for them , the NC is a formula that shows how many times it is found , as well as the CD .

how can I seek them , a macro something to look each numbers of cells CF- CM and look in her right whenever foun

You may have noticed that a file takes more time to download than to delete. This is because deleting a file only removes the door to the data and labels it 'ready to be overwritten'. The truth is that the information still remains on the device's memory and can be recovered with available technology.

Hi all - hoping someone can help me with this relatively simple macro edit that I can't get my head around!

Hello,

I have searched the forums, but can't seem to find a solution to my challange, so here goes. I need a way to automatically remove rows from an Excel sheet, based on the following:

I have a data set with several thousand rows of data on contacts:

Colomns

"Name" "Company name" "Number of employees"

"Randy" "Randy's donuts" "40"

"Sarah" "Randy's donuts" "40"

"Joe" "Joe's trucks" "25"

"Jake" "IBM" "500000"

"Adam" "IBM" "500000"

"Trevor" "IBM" "500000"

"Walter" "IBM" "500000"

"Jacob" "IBM" "500000"

"xxx" "IBM" "500000"

...

And so on...

HI All,

I have a file with data in leniar format.

For example:

Column A Column B Column C Column D Column E
OC ID Client Name Date Mail FTP
OCHY07 HSBC 1 10 25
OCHY07 CENLAR 1 20 30
OCRY08 HSBC 1 10

Now i want a macro to post this data into below format to each respective sheet named acroding to column C(date)

Sheet 1 in other workbook look like

Sheet 1

A B C AA

1 JR Jan german

2 JJ Jan american

Sheet 2

A B C M

1 Jan Feb DEC

2

3

100 JJ

***What i need the formula in cell b100 to do is: if b1 sheet2 is equal to cell b1 in sheet1, then look for "JJ" a100 of sheet2 in the range of column A of sheet1. If the record is found then give me the value of column AA that corresponds to JJ in sheet1, if not leave blank.

Please help, I have been trying to get this since tuesday. Thank you very much.

Please see attached , want to convert 1 line to multiple line with same data , what tool can be used?

Hi-

I need some excel tips in trying to figure out the following data that have multiple columns and value into one columns without eliminating the original first two or three columns.

Original data:

First Last Number1 Qty1 Number2 Qty2 Number3 Qty3 Number4 Qty4
AAA BBB CCC 5 DDD 5 EEE 6 FFF 7
GGG HHH III 1 JJJ 2

Final product:

First Last Number1 Qty1
AAA BBB CCC 5
AAA BBB DDD 5
AAA BBB EEE 6
AAA BBB FFF 7
GGG HHH III 1
GGG HHH JJJ 2

Thank you for any help you can provide I will try to be as detailed as I possibly can be..
On My spread sheet, I have 3 tabs at the bottom listed as "Main Page" "DP Schedule" & "SpreadValues"

The "Main Page" looks like this

Column A = Customer Name
Column B = Contract
Column C = Basis @ Delivery
Column D = Basis When Sold
Column E = Date Product Was Delivered
Column F = Date Product was Sold
Column G = DP Charges That Occurred
Column H = Accumulated Spread Value
Column I = Gain/Loss

Sheet "Main Paige" Column E, represents "Date Product was brought in"

Hello everyone,

What do you think about the idea of automatic verification of your project correctness?

I am working on the tool which helps to verify/test spreadsheet models - exceltested.com

The idea is inspired by unit testing from programming and many stories when Excel mistakes had serious consequences: eusprig.org/horror-stories.htm

Would you find it useful for developing your models?

Thanks

Hello everyone! :)

Let me both thank everyone in advance for any help received and also apologize as I think I only know enough about excel formulas to be just a little dangerous (so to say).

Question is now on brief

Suppose Cell A1 contains 42 Years, 2 Months, 3 Days, how do I tell excel to return 42 Years, 02 Months, 03 Days in Cell A2. Similarly for the following inputs :

15 Years, 6 Months, 13 Days : 15 Years, 06 Months, 13 Days
21 Years, 11 Months, 5 Days : 21 Years, 11 Months, 05 Days
52 Years, 10 Months, 12 Days : 52 Years, 10 Months, 12 Days

The output should contain length of 28 characters.

Excel file attachment is available

Hi,

I have saved an excel file from another computer to my pen drive. The excel file is Macro-Enable file.
When i try to open that file in my laptop, the file not open at all. Yes of course the excel window is opened but with blank blue screen. It doesn't seem like the file is opened because the header of the excel window just as "Microsoft Excel" and not the file name (image attached).

There is nothing i can click in that window except "New" and "Open" in File.

Hello there,

I am working with a large collection of data so I have attached an example where I have only left an example amount of data in but you get the idea. In the actual file there are around 2000 rows.

So what I want to do is to have an identical table on the second sheet but with a formula applied to each of the cells containing a number. The formula would be simple as it is just "3 - x" where x is each of the numbers in the massive table and they would be in their respective positions in this new table on the second sheet.

Hello, I am need of help with data validation for entire row. Task description: build a product selection spreadsheet that will input specific product values from a second sheet in the appropriate cells based on the product chosen from 1 cell.