Hello!
I'm trying to figure out how I can add a Grand Totals column to my pivot chart.
I considered simply making a grand total column that is not connected to my table, but after I thought about it, I need it with the table.
I have the Grand total row at the bottom of the chart, but for the life of me cannot figure out how to make a column on the end of my PivotChart.

I wish if someone could be of any assistant urgently. I have excel files that I have been working on for almost 2yrs now but the windows 8 on my system got crash and the file I recover could not open and I need it urgently.
thank you
Vc

Hello,

I'm hoping that someone can help me. I have a form which has a mandatory cell which needs to be completed before saving (Cell G9).
The workbook has two sheets to it "Day Shift" and "Night Shift"

I am using the following VBA Code, which works for "Day Shift". How do I get it to also work on "Night Shift"?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim cell As Range
For Each cell In Worksheets("Day Shift").Range("G9")
If IsEmpty(cell.Value) Then
MsgBox "You must fill in Pre-rig/Load In Status " & cell.Address
Application.Goto cell

Hi Team,

Please i need a macro code for the following scenario.Attached a sample excel for your reference.

* My excel sheet contains 16 fields, Expiration Date field tells the expiration of the particular software date. So i need a macro code that will send me a reminder mail before 30 days of expiration date for the particular software. The expiry date should compare with today's date.For a particular software if the expiry is more than 30 days of today's date it should automatically send a reminder mail stating " Your XXXX (Software name) is going to expire in another 30 days"

I am having an issue on Excel. I have a drop down menu in cell D5, with three options, A, B, and C.

If A is to be selected, cell content in D6 should become zero/clear-out [i.e., available for manual input by user], and cells D7, D8 and D9 should be locked while having formulas assigned to them as follows: for D7, =D6*G9, for D8 = D6*G10, for D9 = D6*G11

Similarly, if B is to be selected, cell content in D7 should become zero or clear-out, and cells D6, D8 and D9 should be locked while having the following formulas assigned to them for D6 = D7*G8, for D8 = D6*G10, for D9 = D6*G11

Hello, I have a question about, what to do to solve a task where is 8 employees and 8 jobs, each one employee should take only 1 job, and it should be done this, so that to take a minimum time for all 8 jobs done.Here is an excel table attached below.

I've been struggling from last few days and this is my first post here.

Actually I am working on one excel report where in one tab of that report I have got the historical data of all the weekdays where all metrics are in column A and the heading has got the dates only (Starting from column B5 onwards). And I want to create all MONDAYS, TUESDAYS etc report from this historical report in the same workbook but in separate tabs .

So for: B5, C5, D5, E5, F5 (G5 column is used to separate the weeks)

How can I make the grid-lines in Microsoft Excel (2007) like this in the picture ?
In population pyramid, I need dot grid lines on one side and solid lines on another side!
I can make either dot ones or the solid ones but not both ones in a single graph? Can anybody say me whats the trick ?

good Afternoon
Appreciate it if someone can assist me with this sum query - I think the answer is sumif but I just cant seem to get it to work

I have a column of figures

A1 200
A2 100
A3 300

TOTAL 600

What I am trying to achieve is if id the total of column A is less than £500 then I want the asnwer to show as £500 but if it is more than £500 then I want the correct answer to show - in this example 600
Basically im trying to show a minimum charge of £500 as the answer if the column say only adds to 350

hopefully one of you clever people out there can help me !!

I'm stuck on a couple macros and would really appreciate any help. I need two different ones:

1. Delete all columns that HAVE NOT BEEN edited at all (text modification, added, etc.)

2. Delete a specified range of rows that have been edited at all (text modification, added, etc.)

Thank you all in advance! I'm having a terrible time trying to figure out how to get excel to understand that a change has been made to the document.

when I hyperlink from powerpoint the "mini" web bar shows up at the top of the spreadsheet and uses the first lines. I have removed the specific items from the bar (back, forward, refresh, etc.) but the mini bar remains at the top of the spreadsheet.
How do I get rid of the web setting from the customized toolbar. also would be nice to remove the "worksheet menu bar"... but can live with it.

the "web" bar doesn't show up if I open the file by itself but does when I link the same file from powerpoint...

sure could use some help

Good afternoon,

I am hoping someone can help me with a problem I have. I have changed the actual details of the issue but the fundamentals are the same.

I want to add the total cost of a particular item, in this example red balloons. Explanations of cells are as follows:

Cells B1:O1 = Item
Cells B2:O2 = Quantity of items in an order
Cells B3:O8 = Number of orders for each item and quantity
Cells B11:C16 = Rate item charged at
Cells C19:D32 = Cost per quantity of item

Hi!

Whenever I refresh my workbook, Excel creates 16 new worksheets. Could someone help me out with this? The workbook is connected to a database and no macros or scripts are used. It looks like it creates one sheet for every table in my Excel.

Hi all,

I cant find anything on how to do this so apologies if it already exists.

I want to have a series of about 10 questions in excel that you select the answer from a drop down, I then want depending on each answer it to pre-fill a draft letter in word or excel.

does anyone have a template of anything like this that i could have and alter to my own? or could anyone help?

Look forward to your repsonse,

Regards

Joe

Hi Everyone

I'm new to this forum so I'm just finding my way around.

I have a worksheet that in column A has thousands of rows of text. The text is only in column A and can be null or have up to and over 1000 characters. I need to run a macro that will loop through column A and copy each one into column B and if the text is > 60 characters it needs to chop it into chunks of 60 into columns. I have the following code which counts the characters and copies into columns if its over 60 but cannot find anything that will loop through each row or copy anything that under 60 character's.

i want to be able to change the titles but if i enter title 4 I want to pull the rows beneath it that are checked.

For instance title 4 would return the following values
a red
c yellow
e blue
f purple

if title 1 is entered the formula would return
a red
c yellow
f purple

procedure description title 1 title 2 title 3 title 4 title 5
a red x x
b orange x x x
c yellow x x
d green x x x

There are 4 methods of payment: annualy, quarterly, semestrial and monthly. For all of these methods we calculate a number of installments (to pay) by the end-user.
First 3 years are presented like in the picture.
Starting with the 4th year, the promotional plan is no longer valid, so the rest of the payment plan is like the annual one.

Please help me out and advice me how can i calculate the whole payment plan

Greetings Friends,

Below shown is part of a pivot table.
The data range is actually huge to the range of 58,000 plus records.
These are call center data spooled from the server to excel.

Now, I need to filter only those in the labels that end with:-
FORD
JLR
FM
POC
FER
MAS

How do I go about doing so?
Can this be accomplished easily via some VBA method other than on a pivot.
Kindly refer to the attachment for the pivottable.

Regards,
Philip

Hi again, and thank you for taking the time to check out my problem.

I am still not confident using VBA but have tried to amend code to enable me to get the functionality I am after, but I have failed.

I'll try to break it down for easier reading (hopefully).

The objective:
Whenever a user clicks on a macro button on the Outlook toolbar, it will open a specific Excel file, whereby the user selects a number and an Item Description which then opens an Outlook email with the selected number and Item Description in the Subject field.

3 stages:
Stage 1:

Hi all,

I'm a newbie here, so I'll start by saying hello!

I am using some code (that I got from the Contextures website) which makes an active x combo box (named TempCombo) appear in any cell which contains data validation.

HI!

I need som help resolving a VBA problem.

I can't get it to do the task every sec as i whant to it does it one and then stops.

Dim TimeToRun

Sub auto_open()
Call ScheduleCopyPriceOver
End Sub

Sub ScheduleCopyPriceOver()
TimeToRun = Now + TimeValue("00:00:01")
Application.OnTime TimeToRun, "CopyPriceOver"
End Sub

Sub CopyPriceOver()
Set mycell = Cells(65000, 3).End(xlUp).Offset(1, 0)
mycell.Value = Now
mycell.Offset(0, 1).Value = Range("D7").Value
Call ScheduleCopyPriceOver
End Sub

Sub auto_close()
On Error Resume Next

There are 4 methods of payment: annualy, quarterly, semestrial and monthly. For all of these methods we calculate a number of installments (to pay) by the end-user.
First 3 years are presented like in the picture.
Starting with the 4th year, the promotional plan is no longer valid, so the rest of the payment plan is like the annual one.

Please help me out and advice me how can i calculate the whole payment plan

Help. Drop Down Menu to return table of data

Hi

I'm really stuck with this and not sure where to start and cant find a tutorial anywhere which may be because I am searching for the wrong keywords.

Basically I work in a school and want to do the following:

On Sheet 1 have a drop down menu of all the subjects we offer, in sheet 2 I have a table of data for each subject which looks like this (only bigger)

C B A
3 34 45 52
4 23 63 34
5 12 23 53

Hello,

I am after a formula for the following

if a2 is less than or equal to 250 then return 1
if a2 is between 250 and 500 then return 2
if a2 is between 500 and 750 then return 3
if a2 is between 750 and 1000 then return 4
if a2 is between 1000 and 1250 then return 5
if a2 is between 1250 and 1500 then return 6
if a2 is between 1500 and 1750 then return 7
if a2 is between 1750 and 2000 then return 8
if a2 is between 2000 and 2250 then return 9
if a2 is between 2250 and 2500 then return 10

I have this so far

=IF(A2<=250,"1",IF(A2<250,A2>=500,"2"))

Hi, what I'm trying to achieve is changing cell's content, color etc. when selecting (clicking on) that cell. I need to do this in particular range.

Basically I need something like this, but for any cell within given range:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Range("A1"), Target) Is Nothing Then

     If Not (Application.Range("A1").Value = "X") Then

Hi there,

I've been working on the holy grail of excel formulas to solve my current labor intensive excel work.

A startup company entrusted me to figure out their monthly orders based on a yearly total that they give me.

They also wanted me to take into account if the orders are spread evenly or "ramped up" incrementally over the year, depending on what they choose.

I created an excel solution that solved this, for a while. For example 10 orders spread evenly over 12 months was 0.8, or alternatively, a "ramped up" spread is 0.2 in Jan, 0.3 in Feb to 1.5 in Dec.

I'm working on a project where I need to extract data that comes in a relatively poor format. The data consists of stock and bond holdings for a particular client and I need to loop through the data and pull out the market value, percent assets, rating, etc from the information. In column A there is there is a repeated account name that occurs every 2-3 rows. I'm having trouble figuring out a loop that can recognize the account name and then offset and extract the other data.

Hello, I'm trying to code a little program to check if my matrix is symmetric. I have a 96x96 table (with headers on row A and column one that should be counted out) that should be symmetric (e.g. B4 = D1, C4 = D3 etc...).

I accidentally modified some cells, thus it's not symmetric anymore.

I would like to identify cells that are not identical (symmetrically speaking), using VBA. I had a few ideas using While loops but couldn't get through with it :-/ Any help?

It's supposed to be a symmetrical matrix containing only ones and zeros with ones on the diagonal.

Hello,
I have created a Userform for Data entry, which I use at office. All the codes are working, except one, which I’m not able to figure it out, hence need your help.
Userform has fields as (DATE, PS ID, ALERT and CATEGORY), when click submit button save data to worksheet and REPORTS pull the whole/complete data to other sheet.
I have other comman button (Pull Reports) and two text boxes. In text boxes I want to enter dates like start date and end date and when click Pull Reports button, it should pull the data between that date range to other worksheet, in ascending order.

01/01/2015 00:00 4.64 01/01/2015 05:21 1.65
01/01/2015 11:35 4.95
01/01/2015 17:42 1.7
01/01/2015 01:00 3.89

01/01/2015 02:00 2.98

01/01/2015 03:00 2.25

01/01/2015 04:00 1.84

01/01/2015 05:00 1.66

01/01/2015 06:00 1.72

01/01/2015 07:00 2.15

01/01/2015 08:00 2.89

01/01/2015 09:00 3.71

01/01/2015 10:00 4.42

01/01/2015 11:00 4.87

01/01/2015 12:00 4.91

01/01/2015 13:00 4.45

01/01/2015 14:00 3.61

01/01/2015 15:00 2.71