Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Use macros to hide and unhide certain rows on another sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Use macros to hide and unhide certain rows on another sheet
Hello All, In this attached file I am looking to keep the current macros that I have (if at all possible) and add the following: A macros that can link the check boxes with the corresponding categories and rows in the other two sheets. If the box is checked the corresponding rows in the other...

Excel Help Forum - Excel General: Equation(s) That Will Automatically Find Bad Data And Correct It.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Equation(s) That Will Automatically Find Bad Data And Correct It.
On a weekly basis my team has to run a large excel export from a database. With thousands of data rows and columns, most of the information is correct, but some of the information is not and must be manually located by our team and manually corrected in each cell before submitting it to management....

Excel Help Forum - Excel Programming / VBA / Macros: Help!!!

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help!!!
Hi, I am trying to copy text from multiple specific cells and send the text to another sheet in a spicific cells. Also, once its done coping and sending that the text was copied orginally would bet delted automaticly. At first i used a button and code. (didnt work) then macro(didnt work) so im...

Excel Help Forum - Excel Charting & Pivots: Configuring Pivot table to display certain data

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Configuring Pivot table to display certain data
Hi: Please refer to attached sheet. I am using the pivot table as shown. Column K shows Week# Column L shows the total hours worked in that week. I need to see if it is possible to configure the pivot table so to display weekly data only which has over 40 hours. Please help.

Excel Help Forum - Excel Programming / VBA / Macros: Help to return only first 12 characters when a cell contains specific text

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help to return only first 12 characters when a cell contains specific text
Hi Guys, I have a spreadsheet which has some unnecessary characters added onto the end of some records which I need to remove. I am essentially trying to ensure that if a Cell in column A begins with (or contains) "PR" that it only returns the first 12 characters. Other records in column A may...

Excel Help Forum - Excel Programming / VBA / Macros: Trouble with an algorithm. Multiple data sets based on date.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Trouble with an algorithm. Multiple data sets based on date.
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Excel Help Forum - Excel General: viewing pictures in excel

Feed2Mail notification - new post on Excel Help Forum - Excel General
viewing pictures in excel
This may be a simple issue but it has me stumped. Suddenly when I open excel files, pictures are no longer displayed. Some had been inserted from a tiff file but others had been pasted in. For the inserted pictures there is the message: "The linked image cannot be displayed. The file may have been...

Excel IT Pro Discussions Forum: Comments don't stay with row in external data table upon refresh

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Comments don't stay with row in external data table upon refresh
I have a table of data obtained via query from an external ODBC data source. I've added a column at the right where I make comments. When I refresh the table the comments do not stay with the original row. Can anyone explain why and how to fix this?

Excel Help Forum - Excel Programming / VBA / Macros: File System Object Issue.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
File System Object Issue.
Greetings: The code below is used to copy a folder and all its contents. It works great and is quite fast when run across a local drive, and even when run across a shared drive close to me in the network tree, if I'm using the right term. The problem is that when I run it across a shared drive...

Excel Help Forum - Excel Charting & Pivots: Use of data from drop down menu and date ranges for pivot table

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Use of data from drop down menu and date ranges for pivot table
Hello, I'm new on the forum and appreciate the help. I created a weekly marketing count report in Excel 2004 (Mac) that counts new prospects sorted by marketing source (where they heard about us). The marketing sources are on a drop down menu to make it quick and easy for our staff members to add a...

Excel Help Forum - Excel Programming / VBA / Macros: Running a macro when the workbook name changes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Running a macro when the workbook name changes
I have a macro that reads Workbook 1 and puts certain info into Workbook 2. The problem is that Workbook 1 changes its name depending on the week we're in. Workbook 1's name right now is Consolidated 2012-08-18 to 2012-08-24 V2.xls but as you can tell, that's from August. Workbook 2's name is...

Microsoft Word - subject - line spacing in Word 2010

Microsoft Word - subject - line spacing in Word 2010


subject - line spacing in Word 2010

Posted: 25 Oct 2012 09:32 AM PDT

I am a traditional touch typist.   I am used to using the Enter key to move down to the next line - the original position for the "return key" on the traditional typewriter.   I have tried to use this to move down one line when entering an incomplete line of text but I find the next line of entry is double space between lines.   The single line entry works fine when entering a full line of text as the system automatically finds its way to the next line but how can I move down only one line space to enter text which does not fill the space - margin to margin.   For instance - entering an address which is obviously not going to spread across from margin to margin.

I cannot change the habit of a lifetime as a traditional typist and need to be in control of line spacing of my own choice - not what the computer and Mircrosoft thinks I need.   Please give me the option of using my keyboard as a traditional typist and leave the gismos to those who are not keyboard savvy.   Is this too much to ask.   Please tell me how to turn off the facility which is turned on to accommodate the new generation and let me decide when I want single line spacing and double ( by the time honoured method of pressing the return key twice.

 

 

 

 

 

Custom Template location of Word in Office 2013

Posted: 25 Oct 2012 06:10 AM PDT

Where can I find my custom Word templates in Office 2013?

Word 2007, I cannot view the full content of the first page of a document when in the print view but when in full screen view i can see the full contents of the first page of the document

Posted: 24 Oct 2012 03:29 AM PDT

I have a few documents in word 2007 that once opened i cannot see part of the contents on the first page in the print view (default), i can see the full content of the second page fine.

 

When in full screen view i can see the full content of the first page fine.

 

I need to edit these documents but in full screen view i cannot make the changes i need to.

 

Does anyone have any ideas?

 

Office SP3 installed, and latest compatability pack has been installed.

Word 2010 Mail Merge - missing for every fourth record by clicking Preview Result

Posted: 23 Oct 2012 11:48 PM PDT

Hi, I have done the mail merge by inserting the <<NEXTRECORD>> field.  It shows me first three record on page one.  Record number  forth, eight, twelve etc. are missing.  However, record number 5, 6 & 7 are shown on page two and record number 9, 10 & 11 are on page three and so on.  The following is the format that I created.  Please advise.  Thank you.

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

"how can I save an MS word file that is not responding"

Posted: 19 Oct 2012 05:30 PM PDT

The file is open and just not responding

How can I insert a comment attached to two or more non adjacent segments of text that have been selected?

Posted: 19 Oct 2012 02:39 PM PDT

In microsoft word in order to insert a comment I must first select some piece of text.
I want to insert a comment that is related to chunks of text that are not adjacent, but if I select texts and use the "new comment" command this comment gets attached to the last selected chunk of text.
E.g: in the following text, bolded words represent selected words.

Dogs are the most friendly animals in the world ...
... (more text, probably not related) ...
Cats are so repulsive that ....

Then, I click on "new comment" and the bubble shows up but gets linked just to the last selected piece of text. However, what I want is the comment be linked to both words, for example to say: they both are mammals.

Formatting a section footer in a Word Macro

Posted: 19 Oct 2012 02:10 PM PDT

I am trying to create a macro that inserts a new section into a word document changes the new section to landscape and format the header and footer of the new section.  The macro records OK but when  it runs it formats the page number (by changing the tab setting) in the previous section.  I cannot find a way to stop this.  The formating is done after unlinking the header and footer from the previous section

 

The logic is:

Insert section at cursor

Change orientation to Landscape

Edit new section Header and unlink it from the previous section

Move to Footer

Edit new section footer and unlink it from the previous sectiion

Change the right align tab from 6" to 9" (basically right aligning the page number in the landscape section) - its this bit that adjust the footer in the previous section when the macro runs.

Close footer and return to the main document in the new section.

 

Can anyone help me with the necessary code to make the macro adjust the correct footer tab settings?

 

Thanks

Is there a way to link page numbers in TOC to headings on other pages?

Posted: 19 Oct 2012 12:41 PM PDT

 If headings can be linked, can/will page numbers self correct when changes are made? If so, how is it done. I have Office 2010.

What free products can I use to work on a Word document?

Posted: 19 Oct 2012 10:44 AM PDT

Split From: Install error with Office Customer Preview on Windows XP

what can i use? do you have any other free word products just need it for a couple  of days to do a paper

How do I change the tab options to hide or show as drop downs?

Posted: 19 Oct 2012 10:36 AM PDT

I want to use screen capture with minimal interference from ME Word. I don't want the File, Hone, Insert ... drop down options to show on the screen as they take up too much space. In View, "Full screen" is too narrow (and obviously not full screen) and I just don;t see any option to achieve what I want.

Data collection feature?

Posted: 19 Oct 2012 10:06 AM PDT

Something came up before when I was saving a document, asking about sending data to Microsoft? NOT to do with error reports. I don't remember the name of the feature, but I think I hit never ask me again. I want to know how private my documents actually are. Does anyone know the name of the feature and what information it actually takes? Would it make all content in a document available if I had clicked yes? And if so, how I can turn it off for sure?

Two active cursors in a MS Word table

Posted: 19 Oct 2012 09:46 AM PDT

In a MS Word table I have two active cursors showing up.  When I do something with one the action is repeated with the other.  For some reason the text has been mirrored.  Any thoughts?

My Microsoft Word and Excel starters won't open.

Posted: 19 Oct 2012 08:30 AM PDT

They were both working fine until yesterday. Now it says "cannot open Microsoft Word" or "cannot open Microsoft Excel"

Formatted Autocorrect entries will not save.

Posted: 19 Oct 2012 08:18 AM PDT

When I put in plain text entries into my auto correct 2010 Word, they always save when I close out of Word.  When I put in formatted  text in my autocorrect and if I close out of Word they are gone.  As long as I have any kind of Word document open, the formatted text will save, just lose them when I log off or close my Word program.  I need both plain text and formatted text to save in my autocorrect Word 2010. Thanks

Excel Help Forum - Excel General: [SOLVED] Match data between sheets?

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] Match data between sheets?
Is there a function that can match of unlinked values between sheets 'prod' to 'data', then pull the associated data into the B column? The best was I can describe is through the .xls Attachment 189508 (http://www.excelforum.com/attachment.php?attachmentid=189508) *last question of the...

Excel Help Forum - Excel Programming / VBA / Macros: Copying a sheet without copying the command buttons

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copying a sheet without copying the command buttons
I have a macro that makes a copy of a sheet, changes the name of the workbook and closes. When it copies it includes the 4 command buttons that are on that sheet. How can I copy the sheet and note the command buttons? I have tried changing the properties to don't move, but to no avail they CB still...

Excel Help Forum - Excel General: Display textbox on clicking any chart data series

Feed2Mail notification - new post on Excel Help Forum - Excel General
Display textbox on clicking any chart data series
Hi i have a worksheet with a scatter chart and two series. is there a way upon clicking on any of the series to have a textbox displayed and preferably docked underneath it ? (please see attachment. can someone provide a UDF or point me to right direction please .

Excel Help Forum - Excel Programming / VBA / Macros: Applying conditional formating across multiple columns independently

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Applying conditional formating across multiple columns independently
It was suggested that I cross post my question from the formulas forum here. I was given a solution that saves quite a bit of time but a macro may be better? After many hours of google'ing I come before you defeated. The attached sheet is an array of various sales offices and their sales...

Excel Help Forum - Excel General: IF THEN statement and Tables

Feed2Mail notification - new post on Excel Help Forum - Excel General
IF THEN statement and Tables
I am attempting to create a table in excel that will automatically fill out another table depending on the outcome. For example, if A3> 0, then A1, but if it is not, then check A4>0, then A4, etc. I've attempted it in this manner so far, but when I get past the first one I always seem to get...

Excel Help Forum - Excel Programming / VBA / Macros: userform that will search name and pull results from a seperate workbook

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
userform that will search name and pull results from a seperate workbook
I have created a basic spreadsheet with multiple columns and will be entering data daily to the fields. However, I will have others using the form to search for people on the spreadsheet and they would prefer having a command "Search" button for a person(s) name instead of using filters. I have a...

Excel Help Forum - Excel General: quickest method for dynamic link to closed workbook

Feed2Mail notification - new post on Excel Help Forum - Excel General
quickest method for dynamic link to closed workbook
Im looking for the quickest known solution : I need to link to over 52 separate workbooks and pull back a number of cells. the problem is that depending on what week we are in some workbooks will not exist. but i need the links to stay live then update when the sheets do exist. Ive tried...

Excel Help Forum - Excel Charting & Pivots: Unknown chart type

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Unknown chart type
Here is a chart we use in a presentation. It's just an image but it looks like it was created in Excel and I want to update it. I have made many Excel charts, but I don't know how to create a chart like this. The X axis is time in years. The first row is showing that birth records exist in database...

Excel Help Forum - Excel Programming / VBA / Macros: Burning Excel program to disk with Youtube videos

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Burning Excel program to disk with Youtube videos
Hi All, I've been running in circles trying to figure this out: Is it possible to create an Excel program which uses a form with alot of rows of VBA buttons and burn it to a disk? It's not intended for the web. When clicked, each button would play a specified Youtube video. The user...

Excel Help Forum - Excel General: Creating Date Ranges

Feed2Mail notification - new post on Excel Help Forum - Excel General
Creating Date Ranges
Is there a way possible to take a date range Ex: (1/1/2007-6/1/2007) and create in the excel file a list of each of those months. So I want it go from: Stmt Start date Stmt End Date # of Documents 1/1/2007 6/1/2007 6 TO end up like this : Stmt Date 1/18/2007...

Excel IT Pro Discussions Forum: Excel 2007 does not prompt user that the file is opened by another user. Thi...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2007 does not prompt user that the file is opened by another user. This is NOT a shared file.
We have had multiple incidents where 2 employees access the same file but neither are prompted that it is in use.  This is NOT a shared file so why does it not prompt?

Excel Help Forum - Excel Charting & Pivots: Switching axises

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Switching axises
I have this chart (see attached) that I want to change the x axis for the y axis and the y axis for the x axis. Attachment 189413 (http://www.excelforum.com/attachment.php?attachmentid=189413)

Excel Help Forum - Excel Programming / VBA / Macros: How to dynamically update links based on data (not Cells) in PowerPoint via E...

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to dynamically update links based on data (not Cells) in PowerPoint via Excel?
Ok say I have an Excel sheet that gives me all my data and each section in that Excel sheet is linked (embeded object) to a PPT slide. How do I get the data in the powerpoint slides to update based on data (primary key) rather than cell position? For example (see excel data source table below): If...

Excel Help Forum - Excel General: Organize List of Reps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Organize List of Reps
Good Afternoon, Within Column A exists sales reps names; I.E. bob billy brooke bob