Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Is it possible to create a mailing list in excel, not importing d.

I would like to create a mailing list in excel, entering each address in, not
importing it from somewhere. Can excel do that? Or do I have to import the
data, entering the addresses in a different software and doing some sort of
mail merge with excel? Thank you in advance for your answer.


Post your answer or comment

comments powered by Disqus
Is it possible to create a dynamic range in CONTROL TOOLBOX (form).

I have tried this:

1) in the ListFillRange: Listing (refer 2)

2) Name Range:
Called: Listing
Syntax: =offset(Sheet1!$E$2,0,0,CountA(Sheet1!$E:E),1)

But somehow the form doesn't pick up the new data in the name range.

Is there a way to automate this?

Thanks.

I have never used excel as a base for a report. Normally I use Access. Is it possible to create a summary report in excel?

(See the attached excel sheet.)

If it is what I am trying to do is make a weekly report of inspections that are outstanding. I know this will not be a simple task but I need direction on where to start.

I'd like to have something like this:

Week ending 11/14
Bldg CO0533 - 2 incomplete
Bldg CO0627 - 1 incomplete
Bldg CO1572 - all completed
Bldg CO1917 - 2 incomplete

I am wondering is it possible to create a round button in excel spreadsheet?

Thank you in advance

I am using excel 2003 to count my inventory in the following manor:

I have a "database sheet" that is comprised of possible inventory SKU numbers.

I have a "scanned sheet" that lists all the SKU's that I have scanned in the warehouse

I have a "count sheet" that counts the number of times each SKU in the database appears in the "scanned sheet"

Question 1: Am I going about this in the most efficient manor?

Question 2: Frequently, new Items appear in the warehouse that are not yet in my database. Is it possible to create a list of SKU numbers that do not have a match in the database? As it stands, any SKU numbers that are scanned but not already listed in my database - simply do not get counted.

Thank you,

-Bob

Is it possible to create a workbook within a workbook?

hi experts!
is it possible to create a time-scale (of course with different activities but continously upadted) using charts? the chart type will be stacked bar
how? please advise...

thanks a lot

Using Office 2003, is it possible to create a hyperlink from a Word document
to a specific sheet/named cell in an Excel book.
--
Thanks in advance,
MarkN

Is it possible to get Sheet Names List in a Data Validation List in a particular cell

Dear Forum,

I know by using the formulas we can get the Sheet Names, however I want to get the List of Sheet Names in a particular cell D1 directly when the Sheet is Activated..

I got this code while googling

http://www.ozgrid.com/forum/showthre...t=61138&page=1

Sub SheetNames() 
    Columns(1).Insert 
    For i = 1 To Sheets.Count 
        Cells(i, 1) = Sheets(i).Name 
    Next i 
End Sub
However, this code inserts a Column before the First column when I call this Function wfor the Worksheet_Activate Event..

I want to have the same list appear as a Data Validation List in the cell D1 directly so I dont reserve the space for storing the Sheet Names anywhere..

Warm Regards
e4excel

Is it possible to do a conditional subtotal? I have used the Conditional Sum
feature many times, but I want to do a Conditional Subtotal, and I can't seem
to get it to work. Any Ideas?

Is it possible to embed pictures or graphics in Excel?

Hi there

I have Excel file with names (1st column) and e-mail addresses (2nd
column). If I want to add all these names into the Outlook's Contact
list, there is no problem. I use something like as follows
*********************
Set olApplication = CreateObject("Outlook.Application")
Set olNameSpace = olApplication.GetNameSpace("MAPI")
Set olContactFolder =
olNameSpace.GetDefaultFolder(olFolderContacts)
Set olContactItem = olContactFolder.Items.Add
With olContactItem
.LastName = *****here I read from file
.Email1Address = *****here I read from file
.Save
End With
**********************
it creates new item in Contact.

My question is - is it possible to create NEW DISTRIBUTION LIST using
macro? I mean all names/e-mail addresses from the Excel file will be
stored in the new distribution list in Outlook, so these new contacts
will not be mixed with my "normal" contacts

Thank you very much for all comments.

Cheers
Johny

I've been looking through threads to no avail to see if its possible to create a textbox, name it, and place it in a location by using a cell range.

So I'll ask.

Is this possible and if so how is it accomplished or if you know a thread similar to this please let me know.

Thanks,
John

Hello all.
Is it possible to pass a parameter into Excel Query that uses IN operator.
Something like
IN([Param1])
where
Param1 refers to a cell in a worksheet and contains a list.

I tried to pass things like
A1=" 'first', 'second','third',..."
A1="first, second, third, ..."

nothing seems to work.
Thanks!

Is it possible to create a Dictionary/Lexicon where you just add words and their meanings as and when you come across in one tab and in another tab "Search" you have 2 Dropdowns 1. Alphabets--(A,B,C,D,....Z)
and the other dropDown Consisting the Alphabet selected in the first drop-down wher all the words are placed in a Chronological Order..
so if "A" were selected all the word begiing with "A" should appear in proper order..

Example.
Drop-Down Words-DropDown
A Apple
B ***
.
.
.
so
on

whatever added in any order should be placed in a sequential order..
for example..the word ***[I] should not come not appear before the word Ant as within the Alphabet "A" the letter "N" precedes by "S"

thanx in anticipation..

I get various downloaded reports out of SAP...I have a macro that does some formatting, analysis, etc....the problem I am having is that my downloads can vary in length...I have tried using the shift-end-arrow down as a keyboard function, but it marks the end of the range from the original source...

Also, is it possible to have a logical statement perform function? Let say: if a cell is blank, then delete it?

Thanks

Lets say i type some keywords in a cell then is it possible to give me the names of all the files in my computer which contain similar stuff...

IS it possible to use Excel Platform to search for any files by providing the closest name and extension..

If yes that would be really intersting to know the logic and code used ..

So all you Wizards pl
Please attach the file..with proper explanation
It would be a learning experience as i find this site extrememly useful

I have 4 columns of data
first column is a list of US cities

second columns is the change in population from 1990 to 2000 for the
cities
in the first column

third column is a list of US cities (not all the same cities as the
first or in the same order)

fourth column is the change in average income from 1990 to 2000 for the
cities in the THIRD column.

I want to turn the 3rd and 4th columns into a psuedo hash table so that
I can match the cities in the first column with the third column, and
then store them in cells corresponding in order to the first.

Is it possible to match text this way in excel using functions and not
having to write a VBA script?

i want to create a dropdown list in excell that will highlight a word when
first letter is typed

Is it possible to create new folders based on text within a document

(Word 2007)
Option1: I have a huge mail merge document that I need to split and group based on text in the document. If i run the following code while still in Mail Merge (before the Finish & Merge step), it gives me exactly what I want except the files are saved as merged documents. I don't think I can convert this to a regular "un-merged" file.


	VB:
	
 GrpMerge() 
     
    On Error Goto ErrorHandler 
     
    ActiveDocument.MailMerge.ViewMailMergeFieldCodes = wdOn 
     
    With ActiveDocument.MailMerge.DataSource 
        .ActiveRecord = wdFirstRecord 
        Do 
             
            On Error Resume Next 
            MkDir "C:Temp" & ActiveDocument.Fields(3).Result 
            On Error Goto 0 
             
             
            ChangeFileOpenDirectory "C:Temp" & ActiveDocument.Fields(3).Result 
            ActiveDocument.SaveAs FileName:=ActiveDocument.Fields(4).Result & _ 
            "_" & ActiveDocument.Fields(5).Result & ".docx" 
             
             
            If .ActiveRecord  .RecordCount Then 
                .ActiveRecord = wdNextRecord 
            End If 
        Loop Until .ActiveRecord = .RecordCount 
ErrorHandler: 
         
    End With 
     
End Sub 

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

Option 2: On the other hand, I have code that will split a merge document and save it in one location. I've modified it by (1) using the merge fields to create the new path and file, then (2) creating a variable to place the path file. But I'm stuck once the text is copied, how do I set my variable?

	VB:
	
 BreakOnPage() 
     
     
    Dim strNewFileName As String 
     
     
    Application.ScreenUpdating = False 
     ' Used to set criteria for moving through the document by page.
    Application.Browser.Target = wdBrowsePage 
     
     
    For i = 1 To ActiveDocument.BuiltInDocumentProperties("Number of Pages") 
         
         'Select and copy the text to the clipboard
        ActiveDocument.Bookmarks("page").Range.Copy 
         
         
         ' Open new document to paste the content of the clipboard into.
        Documents.Add 
        Selection.Paste 
         ' Removes the break that is copied at the end of the page, if any.
        Selection.TypeBackspace 
         
         'Find and copy the text of the file name
        Selection.GoTo What:=wdGoToLine, Which:=wdGoToFirst, Count:=40, Name:="" 
        Selection.EndKey Unit:=wdLine, Extend:=wdExtend 
        Selection.Copy 
         
        [B] 'How do i set my variable = to the copied text?[/B]
        [B]    strNewFileName = ??[/B] 
         
        ActiveDocument.SaveAs FileName:=strNewFileName & ".docx" 
        Selection.Delete 
        ActiveDocument.Close 
         
         
         ' Move the selection to the next page  in the document
        Application.Browser.Next 
    Next i 
    ActiveDocument.Close savechanges:=wdDoNotSaveChanges 
     
    Application.ScreenUpdating = True 
End Sub 

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


Thanks

Hi is it possible to populate a drop-down list (data validation) field with data from a database? In my case the database is MySQL. If so does anyone know how I can do it? Or know where there is an example of how?

Hi,

I would like to know if it is possible to create a histogram from data
in excel. I have approx. 30000 values in a column that varies from
0,001030093 to 276,9992477.

It would be great if I could get a bar chart with like 5 bars where
each bar shows the number of values within a particular range for
example 0-2, 2-4,4-10, 10-100,100-300.

I've tried to use the program Minitab but I cant seam to get it
right.

Is it possible to Compress a Folder/File or create a Zip File Dynamically?

I have realized that VBA has a great potential and I have managed to create Files and Folders Dynamically using VBA coding..ofcourse with a lot of great help from the forum..

Going forward in saving time is it possible to Compress the Created Folders or any any Folders in a Given Path..

Like a WinZip file which can be an email attachment or on Pen-Drive..

Warm Regards
e4excel

Hi,

I have a column that represents the weekday (number from 1-7) of a date
by using the worksheet weekday function. I used the custom format "dddd"
on that column to display the values as days (Sunday, Monday, ....)
rather than numbers.

Question: I want to display the days in a different language without
having to change the regional code of the PC. Is it possible to create
my own custom format that changes the way the column is displayed
_without_ changing the underlying value which is a number from 1-7?

I tried writing my own weekday function which displays fine but the
problem is that it also changes the underlying value of the cells which
I don't want to do as this affects other calculations.

Thanks for any help on how to tackle this problem!

When I sort a simple list of contributions (for instance) and it groups say
weekly
contributions to an organization, is it possible to get a sub-total for that
grouping???
If so, how?

Thanks


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