I am trying to subtract time. I can get the answer if Start time is 8 am and Stop Time is 4 pm. I can't seem to get the right answer though if the shift works night and Start Time is 10 pm and Stop Time is 6 am. Can someone help with how to subtract time when it goes to next day

I am working on an analytical problem where some information from the Amazon EC2 calculator would be needed.

I have a spreadsheet that will perform some criteria analysis and for each iteration I will need specific cost of services provided by AWS.

My solution invokes, in a user form, AWS simple calculator, allowing the user to specify the type of services he will use from AWS, then by pressing a button, placed on the same user form the value of his Total Monthly payment must be parsed to a cell in the main workbook. That operation should be repeated for each of the test scenarios.

We offer Para transits rides to people. but I have a list of clients that I cant offer rides to anymore. the list is about 500 names long. I need to have an alert or highlight a name if it pops up. Any one have any ideas on how to make this happen in excel?

Hi,
I have a chart with 10 different Y data series and one x data series. Points are linked together with lines for Y1, and another graph for Y2 and so on. Y1 lines are colored as red, Y2 as blue, and so on in different colors.
I can change the color of the first graph Y1 by selecting this and changing the line color to black. I can change the color of the second graph Y2 by selecting this and changing the line color to black. And I can do so until I got mad.
Can someone expert tell me how to select all the graphs and just change the color in one step for all my series?

Hello,

I understand how to reference a cell to have the same text as another cell in a different worksheet, but how do you also get excel to change the color to be the same?

ie Sheet 1: I change A1 to Red fill and the text ABC
Sheet 2: B1 automatically changes to Red fill with ABC as text

Thanks

I have hundreds of reports in word format that I would like to have organized in an excel table to be able to filter and find data easily among other uses. The reports are formatted correctly with headers for the sections etc. I'd like to have a column for each section header (and one for sub sections) and a separate column for the corresponding paragraph. How can I do this?

Hi! I am new to VBA scripting and. I am trying to have excel search for text in one column and categorize that text with a text value in another column. For example, I have column L with the list below

Column L
Logical Disk Free Space is low
Center: VC Application Error
Megabytes of Memory is too low
Megabytes of Memory is too low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Metric CPU Usage = 91%
WMI is unhealthy

I currently have an Excel macro that copies a file specified in cell B6 and renames the file using the value in cell D6. Cell B3 and D3 contain the source and destination folder paths. When I run the macro it works great. However, I'd love to be able to copy/rename multiple files based on a cell range (e.g., D6:D100) instead of just one cell (D6). So essentially creating a loop until the last "rename" value is reached within the range of D6:D100. I've provided my current working code below:

-----BEGIN CODE-----
Sub CopyRenameFile()
Dim src As String, dst As String, fl As String

I have a quick question. I'm supposed to type in the data from the book in a table. Some of the data, which includes dates, are the same. When I tab to the next row down as usual, it gives me an error. How can I fix this problem so I can finish my Access assignment? In case you need to know, I am using Microsoft Access 2013.

how can i send a attachment in reply for any query???

Please, assist me with a formular to use in sorting and counting the number of FCR and ESCALATED issue under the STATUS against QUERY. Please find table below.

QUERY TYPE STATUS
Language Barrier FCR
BB Issue- bundle activation FCR
VAS Issues FCR
Browsing \Data Issue- Customer’s education FCR
Share and Sell Issue FCR
Bonus\Promo Enquiry FCR
Tariff Plan Migration -Enquiry FCR
Credit balance\Missing Minutes Escalated
BB Issue- bundle activation FCR
Recharge Issue- System downtime Escalated
Call Issue-network related FCR
Credit balance\Missing Minutes FCR

Hi All,

I have two tables of data that I would like to compare & contrast. The data in table1 and table2 consists of three colums: date, player ID and score.

For every date and player ID in table1, I would like to highlight the scores in green that match the score for the corresponding date and player ID in table2. Additionally, for every date and player ID in table1, I would like to highlight the scores in red that do not match the score for the corresponding date and playerID in table2. All non corresponding data can be left alone.

I have to raise a large number of invoices every month, which I currently do mainly manually at the moment. I am looking for a way to auto populate from 1 sheet to the next.

So
On sheet 1 I have all the data - name / date / cost, this will feature a persons name multiple times. I then have a separate sheet for each individual that receives an invoice. at the moment I sort the data by name and copy and paste into each sheet. I am looking for something that will say if the name e.g Sue appears add date and price to the sheet called sue.

Is this possible?

Thanks in advance

Hello, I am brand new to this site and would appreciate any help with the following problem:

I have an excel workbook that pulls data from the net every hour on the hour. What I want to do is email the value if it is over 100. My data is in B3-B32. Sample code below does not run the macro automatically, I am missing a step:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("B3"), Target) Is Nothing Then
If IsNumeric(Target.Value) And Target.Value > 100 Then

Hey all, I need little help with conditional formatting. I have year wise sales value of different years (2010-2015) of multiple regions. I want to put up an icon based conditional formatting, which shows if any year post 2010 was higher, lower or equal in sales of 2010. And i want to drag the conditional formatting for all regions. Can anyone please help me with this?

Hi,

I need to figure out how to sort this one column into 3 different columns (attached):

First Name Last Name
Phone Number
Email

All of the data is mixed up in the original column, what formula would I use to sort them the way I need?

Thank you so much!

Hi,

I need to figure out how to sort this one column into 3 different columns (attached):

First Name Last Name
Phone Number
Email

All of the data is mixed up in the original column, what formula would I use to sort them the way I need?

Thank you so much!

Hi,

I have a few macros tha I have written and I would like to be able to distribute them to work colleagues. The macros are stored in the personla.xlsb file, on my pc. Office version 2010.

Ideally I would like to have a workbook, in which there are separate buttons to install each macros. The colleagues would open this workbook and install the macros that they want. This workbook would access the personal.xlsb file (which I would place on a network drive), copy it onto the colleague's computer and then install the macro in the ribbon and assign it an icon.

Hello everyone:

I have this problem which i cannot get the right answer.. I feel dumb.. and my teacher for some reason, does not want to help me, i believe he hates me just because im of a different religion than his, and where i live people are very discirminative. So i need the help from my internet friends.

Im required to create 2 VBA codings, i believe its using the loop feature.

I will attach the imagen where everything its explained.

Hi

I have an example spreadsheet attached. its a teachers markbook.
When I add further colums of grades to be input the colour coding does not copy and keep the designed formatting from the original.

Can you help please?

Crakkers

I don't think this should be too hard:
I need to see if the data in column B has the word "TRUE". If it does, then I need the data from that same row from column A put into the same row, column C. So in this example, cell B2 has the word "TRUE" so I need 50 to be put into C2.
Thanks for any help!

Gift Amount Team Captain TC Gift
50 TRUE 50
100
25 TRUE 25

I'm made a serchable dropdown menu in excel similar to the one in this link( https://m.youtube.com/watch?v=vkPoViUhkxU ) what I can't figure out is how to make 5 dropdown menues they all need to be searchable from one database/list of customers I have on a spreadsheet. If I link all of them to one list, when I search on one menue the next menue can't serch other customers except the one I chose on my last menue .

I m tired seeking help,

i have a format like this

A1 =days B1= week C1=Month
i want that if A1=6 then b1=6 c1=6 after that if i change a1 value as 4 then B1=10 D1=10 and its keep running B1 till one week and C1 till month

hope you understand

Thanks
Prakash Joshi

Hello,

I have the following data in Excel (see attached file).

I am looking to create a bar graph (sorted from largest to smallest) which can be filtered by "business unit", "Team" and "Sub-team". I only require a summary view, not the individual employee scores. I want the graph to automatically update and sort (largest to smallest) when a filter is selected (want to avoid the use of macros). I am thinking a pivot table would be best.

Can someone please help me out with this.

Thanks!

Hi All,

Your help is highly appreciated here.

I am not able to hide the axis label.

Please find attached image for more details.

Thanks,
Anil Kute

hi folks hoping someone can help, i have a basic sheet for work which shows a date when some made a claim in the next column headed weeks i want it to work out how many weeks has passed since the have claimed i have already inserted a dynamic cell for a updating date field for each time spread sheet is open. also after 13 weeks i want it to highlight automatically

thank in advance

I have a registration/attendance form which contains list of people that attended the the occasion from day1 through day 5. If anyone attended or missed any day, I put "P" for present or "A" for Absent under the each day i.e
Day1 Day2 Day3 Day4 Day5
P A P P P
Now, I want to find for each day, the list of people with "P". I used this formula: =INDEX(Registration!B10:B159,MATCH("P",Registration!N10:N159,0))

I have a folder that opens worksheets one by one, takes information from them, and puts that information into a master file.

I am trying to copy information from one worksheet under the header "CUTTING TOOL", typically that header starts at G10, (copy the information underneath it until you reach the bottom cell) and then paste it into column C of a different worksheet continuing to loop through each worksheet to do the same..

I also am trying to copy information from one worksheet in cell J1 and pasting it into column 4 and continuing to loop through each worksheet to do the same.

Hi,
I have MS Excel 2007 and I have to prepare my team availability matrix for superiors. But I am not a user friendly about formulas and macros. So need your help.

Formula’s or macro required for solving my query.

I have two tables:
Table A - Present Available manpower count

Jun-15 Jul-15 Aug-15 Sep-15
Skill1 1 2 5 1
Skill2 3 3 1 1
Skill3 2 2 2 1

Table B - New Program Requirement

Skill1 Skill2 Skill3
Prog1 2 1 1
Prog2 2 3 3

what should be the syntax for the following by using Inputbox and MsgBox ?

If user name is catalyst range a1:a10 should be selected, otherwise show a message 'Please enter correct name"