Free Microsoft Excel 2013 Quick Reference

church expenses, income work sheets

Our Baptist Church needs:
>A work sheet or data base that we can enter each expense by budget account number.
>Same for income according to budget account number.


Post your answer or comment

comments powered by Disqus
Our Baptist Church needs:
>A work sheet or data base that we can enter each expense by budget account number.
>Same for income according to budget account number.

I really need help. I tried to import an excel worksheet that had addresses
on it to my contacts in Outlook. I think I made a mistake in naming the
cells and rows. It seems to have filled out all of the contacts available.
It took 2 hrs to import CHURCH-ADDRESS-CITY/STATE/ZIP-PASTORS. 4 ROWS!
There were only 25 ministers listed on the work sheet? Seems like to me that
it just kept copying and copying and copying. I need help please.

Need help totaling units by style, color & size on Multiple Purchase Orders

I have master purchase order work sheet, Master, where I have entered what I plan to order for the fall season. I now need to create 4 separate worksheet purchase orders--Sept, Oct, Nov & Dec deliveries based on my total units on the Master PO worksheet (I am on allocation).

My column headings are Style(E), Description (F), Color (G), Size (H), Total units (I), see example. My data starts on row 2.

Style Description Color Size Total Units
1873 W BAILEY BLK 5 2
1873 W BAILEY BLK 6 4
1873 W BAILEY BLK 7 5

For my PO order for Sept, let’s say I order 1/5, 2/6, 2/7, for Oct I order 1/6, for Nov 1/6 & Dec 1/5, 1/6, 3/7. I need a formula that I can use that will subtract the units placed on my Sept, Oct, Nov & Dec purchase order worksheets from the Master PO worksheet so that I know how many units are left to order on the other purchase orders as I enter the units.

Let’s say I create an additional column on the master PO called Balance (J). The formula I am seeking would give me be a balance of 1/5, 2/6, 3/7 left to order after entering the units for Sept.; the balance should be 0 after entering the Dec units. If I change any units on any of the Sept to Dec work orders, the formula would update the balances of units accordingly.

Any help would be deeply appreciated. Thanks.

When saving complex Excel work sheets down to xls all formatting is lost.

Has anyone found a solution to this problem?  I have been working on it for so long

I have a macro that keeps on adding work sheet.I need the sheet to be named say " Ex 1" whenever a sheet is added. Is there a way to do that.. if yes how should I go about that??

I receive workbooks on a daily basis (workbook name and worksheet name changes for each file sent). I am looking for a way to pull specific cell information and place it in a new work sheet (Called Master) that I create within each workbook. Example:
Workbook ABC contains 12 worksheets (as many as 99 worksheets are possible)
I need the information residing in the following cells of all the worksheets:
C2
G2
G4
G5
I then need to place this information into Master as
A2, B2, C2, D2

Thanks

Hello,

I am having the worst time trying to get 2 work sheets to tie together. WHat I mean is: I am wanting to have numbers to auto generate from one sheet to another and have the system keep track. Is this possible or a dream? I have worked on this all week and still coming up with nothing. Can anyone help me out with this teaser?

Thanks!

Dear Friends,
First of all thanks for all your cooperation you have extended to me so far. I need a help in editing the input data from a user form through another user form. For example When I feed data through a user form , it get stored in a predefined work sheet in predefined rows. Now I need to edit the Data That I have fed in another user form(say the Editing Form). In the editing form, I want to recall the data by selecting the heads from the combolist on the form so that, as per the combobox selection the respective data row(Cell values) are shown on the form in different text boxes. Now after displaying the data from the work sheet on the user form(Editing Form), I want to replace/correct some or the other value and save it so that it goes and get saved on the work sheet back.
(1) On the form I should have a SELECT Button to select the data as per the combobox selection to get the respective data displayed on the specified text boxes.
(2) After the data is displayed, I should be able to edit the data displayed in the text boxes and When I click another button named SAVE, the data replaces the values in the cells of the worksheet with the new edited values. It should be noted that un-edited values should remain as they were. Only changed cell values should be replaced (Over written)with new values.
(3) I am Attaching a sample copy of the workbook (nm766_WorkBook_2) . Request please workout the code by which I can be able to edit the stored data.

Thanking you .

Nm766
With regards

Hi Friends,
Can anyone help me on the following issue :

(a) I have a work book say MY PROJECT 1.

(b) In that I have a work sheet say DAILY SCORE DATA. This Data is stored in the Cell Block of E2 to M67. M Column is the sum-total of Column ‘E’ to Column ‘L’ for each row. Means E2+F2+G2+H2+I2+J2+K2+L2 = M2 (and similar for other rows till 67th row). These data are fed from a User form and get stored when OK button on the form is clicked.These data input from the user form is also reflected in another worksheet Say BULL SCORE DATA (Y2:AF67) for Columns E : L. The data of Column M(sum total) is reflected in Column Q of the sheet simultaneously on clicking the OK button.

(c) I need to reset the data in the above said cell blocks (E2:M67 in Sheet DAILY SCORE DATA and Y2:AF67 and R2:R67 in Sheet BULL SCORE DATA) on next day (assuming the data was entered today evening) by clicking a command button (named RESET) on the same user form. As a result the data in cells should reset to ZERO. This should be conditioned with the computer’s date calculation so that if I want to reset on the same day , it won’t reset. It will be reset only on the next day when the computer date changes to next day.

(d) It may be noted that, some rows in random, might contain ZERO data previously. So while resetting, it should not create any problem.

Your precious help will be highly appreciated.
Thanks in advance.

With regards,
Nm766

Morning

I would like to have the work sheet return multiple columns based on a source data.

The source data is on a tab called Master Supplier Listing

The source data will be in column c, starting from row 4 and lookup column a on the Master Supplier Listing.
It will also return column b, c, d and e from Master Supplier Listing to column d, e, g and f respectively in the source tab.

Is this possible?

A1:G1 contain column headings, that I would like to maintain, but is not critical

Data fills down to row 3464 (count=3463) that I would like divide as equally as possible into 6 new work sheets for the team to work.

I have been playing with getting a scroller to control data on four charts at once. I can get it to work but it isn't feasable the way I'm doing it. In my workbook there are up to 10 sheets with 4 or more charts. I am using defined names and following mostly the example posted in this forum for scrolling charts. http://www.ozgrid.com/Excel/scroll-data-chart.htm. The problem is that with so many defined names for each pen on the chart it gets confusing and will take a huge amount of time to set up and keep up with new changes to the workbook. The example I have can't get any smaller than 106k so I can't post it. I deleted most of the data and all but two work sheets. Can someone give me an email to send and review the file or some other way to post it?

Sir,
I need the following helps in preparing a user form controlled work book with multiple variables.

(a) I have created a user form with combo boxes and text boxes as inputs written to a defined worksheet in the work book. This is covering aound 25 columns when the data entered to the user form once and covering the defined row as it supposed to be. How the data could be written to another work sheet simultaneously in the same pattern?

(b) Secondly, how a simultaneous calculation (Sum function) can be done on the work sheet for each time data entered (need to add values of five inputs fed from the user form) and written to next coloumn as specified. For example If my data input is 05 different time durations entered as in put from the User form and are written to the specified worksheet in Cells D3 to H3. Now as soon as the data written on the columns, I need to fill the Cell I3 or any other selected cell in the same row automatically with the total sum of the cell values of D3 to H3. Can it be done with the VBA codes?

Hi there,

I have a small league table which updates using data from another work sheet.
I'd like the the table to automatically sort, in ascending order, when the data is changed on said work sheet.
Can this be done using a formula, or does it have to be macros?

I only know the very basics of excel, so my apologies!

I have attacthed the workbook in question!

Thanks

Hello all any help will be appreciated. I am new at macros and need a little help. I am using a macro to e-mail any work sheet with an address in A1. I would also like to attach a file that will be listed in cell E1 of that worksheet. The file is different for each work sheet that is being sent but will be listed in the same cell of each work sheet.

this is the code i am using (i got it from ron de bruin) when I use the .Attachments.Add (C:test1.txt) it works but i can not seem to figure out how to get it to read the file address in the E1 cell. The code i am trying to use is .Attachments.Add = ws.Range("E1").value Thanks in advance for any help you offer.


	VB:
	
 Outlook_Mail_Every_Worksheet_Body() 
     ' Working in Office 2000-2007
    Dim OutApp As Object 
    Dim OutMail As Object 
    Dim ws As Worksheet 
     
    With Application 
        .EnableEvents = False 
        .ScreenUpdating = False 
    End With 
     
    Set OutApp = CreateObject("Outlook.Application") 
    OutApp.Session.Logon 
     
    For Each ws In ActiveWorkbook.Worksheets 
        If ws.Range("A1").Value Like "?*@?*.?*" Then 
            Set OutMail = OutApp.CreateItem(0) 
             
            On Error Resume Next 
            With OutMail 
                .To = ws.Range("A1").Value 
                .CC = "" 
                .BCC = "" 
                .Subject = "This is the Subject line" 
                .HTMLBody = RangetoHTML(ws.UsedRange) 
                [U].Attachments.Add = ws.Range("E1").value[/U] 
                .Send 'or use .Display
            End With 
            On Error Goto 0 
             
            Set OutMail = Nothing 
        End If 
    Next ws 
     
    Set OutApp = Nothing 
    With Application 
        .EnableEvents = True 
        .ScreenUpdating = True 
    End With 
End Sub 
 
Function RangetoHTML(rng As Range) 
     ' Working in Office 2000-2007
    Dim fso As Object 
    Dim ts As Object 
    Dim TempFile As String 
    Dim TempWB As Workbook 
     
    TempFile = Environ$("temp") & "/" & Format(Now, "dd-mm-yy h-mm-ss") & ".htm" 
     
     'Copy the range and create a new workbook to past the data in
    rng.Copy 
    Set TempWB = Workbooks.Add(1) 
    With TempWB.Sheets(1) 
        .Cells(1).PasteSpecial Paste:=8 
        .Cells(1).PasteSpecial xlPasteValues, , False, False 
        .Cells(1).PasteSpecial xlPasteFormats, , False, False 
        .Cells(1).Select 
        Application.CutCopyMode = False 
        On Error Resume Next 
        .DrawingObjects.Visible = True 
        .DrawingObjects.Delete 
        On Error Goto 0 
    End With 
     
     'Publish the sheet to a htm file
    With TempWB.PublishObjects.Add( _ 
        SourceType:=xlSourceRange, _ 
        Filename:=TempFile, _ 
        Sheet:=TempWB.Sheets(1).Name, _ 
        Source:=TempWB.Sheets(1).UsedRange.Address, _ 
        HtmlType:=xlHtmlStatic) 
        .Publish (True) 
    End With 
     
     'Read all data from the htm file into RangetoHTML
    Set fso = CreateObject("Scripting.FileSystemObject") 
    Set ts = fso.GetFile(TempFile).OpenAsTextStream(1, -2) 
    RangetoHTML = ts.ReadAll 
    ts.Close 
    RangetoHTML = Replace(RangetoHTML, "align=center x:publishsource=", _ 
    "align=left x:publishsource=") 
     
     'Close TempWB
    TempWB.Close savechanges:=False 
     
     'Delete the htm file we used in this function
    Kill TempFile 
     
    Set ts = Nothing 
    Set fso = Nothing 
    Set TempWB = Nothing 
End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hello to all and thanks for the help....I have a work book with a number of work sheets (10 in all) and I and setting up a summary work sheet and I would like to sum all sheet to the work sheet summary sheet is there a formula the can help do this quickly

I.E I would like to sum cell a1 from sheet 1 to 10 ....help thanks

how do I lock, protect, hide formulas in a work sheet

hello to all and thank you for the help....I have a work book with a number of work sheets all the same with the same cell with data within the cells...what i am looking to do is set up a sum work sheet and add the same cells within the work sheets or to say if i have 6 work sheet i would like to add cell D4 across all sheets ....how can this be done.....again thanks for the help

Dear All

Can anybody provide me "strong protection code" for work sheet.

Suresh

I wanted to protect my work sheet, in order to prevent careless users from inadvertently changing my formulas. However, I also wanted to give the user the possibility to group/ungroup columns. It turns out that the latter is not possible if I protect the work sheet. If I try, I only get an error message, saying that you can't perform this command (trying to group or ungroup) on a protected sheet.

Is this the intended behaviour?
Does anyone know of some work-around to the problem.

Grateful for any assistance

Bengt

hello all

I have seen in the past people viewing 2 work sheets/ work books in the same window,

How would i go about doing that

Thanks jason

Hi - First post on here so please bear with me..

I have two excel sheets all containing different data on foreign exchange rates.

Using my criteria from my first worksheet I want to look up data in the other one and import them into my first worksheet.

ie: in my first work sheet I have rows of data that contain a certain rate used at a certain date:

Trd Dt FX Rate Pay Ccy RcvCcy FX
2-Jan-2007 1.320 USD EUR USDEUR

in my other worksheet i also have rows of data that contain a certain rates and codes used at a certain date.

all rates, dates and codes are uniformed in both sheets

what i want to do is be able to type in a formula where the second sheet can look up a certain fx code (last coloum) from my first sheet and give me the value it has at a certain date in a column in my first sheet.

can this be done please as I have tried the vlook up but to no joy !

thanks
rob

Hi, I have worksheet containing 20 link sheets.

I want to see the result on the similar sheet by changing values which effect the other worksheets.

Can I make a link text box or any other tool with my resultent sheet to see the result on the working sheet at a glance. If could help me a lot if I need to variy the figures to get the required result.

Many thanks in advance.

Rgds

Can I make a scrolling section of cells within a work sheet.?
What I am trying to do is make a section of cells scrollable within a work sheet.

Like say make 100 cells in 3 rows, but only display 10 of them on the screen and have a scroll bar to move down past the 10.

The idea is I want users to be able to inter a lot of data on these specific cells but I want to save room on the sheet for other things. Thanks.


No luck finding an answer? You could always try Google.