A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
move to the right after hitting enter using macros by Santa Fe Al
Hi All, I am attempting to cause movement 4 cells to the right of present location after I enter data and press enter. I had thought a Macro would do this,...
November 18th, 2009 08:45 PM
by Gord Dibben Go to last post
2 248
If I have a list of numbers, how do I insert a dash in each one? by rayofsunshine969
If I have a list of numbers, 11 characters long, example: 00229603210, and for each number I want a dash behind every 2nd, 6th and 9th number,...
November 18th, 2009 08:43 PM
by Mike H Go to last post
2 187
text is getting cut off when printed due to row ht. by bkikoen
In my spreadsheet the row heights are varied and look the right way, when I print my spreadsheet the rows are smooshed and text is cut off across the top....
November 18th, 2009 08:37 PM
by Squeaky Go to last post
1 201
How to reset every other row color after sorting by Trish
if your spreadsheet in 07 is set to everyother row color and you do a different sort ...is there an easy way to reset that every other row? I've tried...
November 18th, 2009 08:32 PM
by Gord Dibben Go to last post
2 229
Move data from multiple tabs into one worksheet by Supe
I have a file that has 60 different tabs that shows the vendors UPC, Dollars, and units for their items. Is there a way to move all of those into one...
November 18th, 2009 08:11 PM
by Gord Dibben Go to last post
2 304
Excel 2007 - extracting duplicate names by Cheri
Does anyone know how I can accomplish the following task? I have a spreadsheet that I need to extract duplicate names and all other items associated with...
November 18th, 2009 08:09 PM
by Gord Dibben Go to last post
1 240
vlookup in french excel by Caro
What is the equivalent name for the formule « vlookup » in an french excel ? Thks
November 18th, 2009 08:07 PM
by JB Go to last post
3 253
conditional formatting by joe@malvern[_2_]
I have a conditional format which the formula indicates true for column "A" and column "B" background shades red. how do I set up so columns "A-T" highlight...
November 18th, 2009 07:57 PM
by Gord Dibben Go to last post
3 231
Conditional Formatting with average formula and variance by murkaboris
Hello: Can somebody please advise how to include a variance in conditional formating when using average? i.e. I'd like to highlight cells in red if the...
November 18th, 2009 07:43 PM
by murkaboris Go to last post
9 341
Grouping dates in pivot table by Marc[_17_]
I am pulling data from a SQL Server database to create a pivot table. Excel (07) is not recognizing the field as a date. This is a field I would like to group...
November 18th, 2009 07:34 PM
by Marc[_17_] Go to last post
3 209
How can I autocopy text from one textbox to another using VBA in E by SunFUd01
As above I have bought 3 books in the hope of finding this answer and aslo searched the www till it has now got me demented!
November 18th, 2009 07:24 PM
by SunFUd01 Go to last post
0 203
subtotal data from 2 columns into 3rd column by Tacrier
Is there a formula I can use to subtotal column data instead of using the subtotal feature? When I try using the subtotal feature it puts the subtotal at the...
November 18th, 2009 07:22 PM
by Eduardo Go to last post
1 186
Find the oldest date in an Access recordset by gab1972
I found some coding to find a date range in an Access recordset, but I need a macro to search a recordset for the oldest date. Any help or references would be...
November 18th, 2009 07:08 PM
by gab1972 Go to last post
3 208
Deleting rows with formulas is very slow by gramos14
I have excel 2003 and everytime I delete rows in a worksheet where there are formulas on the worksheet, it takes a long time for the rows to delete. I...
November 18th, 2009 07:08 PM
by gramos14 Go to last post
2 187
Sorting within Groupings by bgc2001
I was wondering if it's possible to sort within groupings in excel. For Example I have a lost of companies in a worksheet in grouped by Sector (i.e. energy,...
November 18th, 2009 07:06 PM
by bgc2001 Go to last post
0 195
Sort according to most repeated entries by Roadtripper902902V3V
Hello, How can I sort a column based on repetition. For example, Anna Bob Bob Bob Bob
November 18th, 2009 06:30 PM
by Dave Peterson Go to last post
3 250
ODBC Problem by chumichael
I set up several spreadsheets that are linked to external data using ODBC queries. It was all working fine until, I got a new PC. I am now able to write...
November 18th, 2009 06:26 PM
by chumichael Go to last post
0 223
Improper Page Breaks by Mazhar
I have created an excel report by running a macro on my machine. When i view the report on my machine it displays the page breaks properly but when the same...
November 18th, 2009 06:00 PM
by Bob I Go to last post
1 196
count and match by Pammy
Excel 2007 I have a spreadsheet with 7 columns and 253 rows, one of the columns has a checkmark if the person responded. I want to filter out all the...
November 18th, 2009 06:00 PM
by Herbert Seidenberg Go to last post
3 199
Automatically Hiding Rows when certain cell value has been selecte by Jason
I am trying to hide rows 13-16 when a certain value has been selected from a named range that contatins a drop down list. Any help will be greatly...
November 18th, 2009 05:51 PM
by Gord Dibben Go to last post
4 175
Post New Thread


Display Options
Showing threads 9821 to 9840 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.