Search results for query: *

I am way over my head on this part. Every month I am creating a pivot table and then splitting it into sheets by the report filter. So, the rows and columns on every sheet change every month. The last row of each table and sheet, says Grand Total so my macro is searching for Grand Total and then...

Hi There- Anyone know an easy way to move macros from one workbook to another without first creating a new macro name and then copying and pasting each one in? Thanks for your help. To everything there is a season, a time for every purpose under the sun.

Hi- I have a pivot table that is linked to another Excel spreadsheet in a separate file and the name of that file changes every month (only 1 sheet in the file). I have gone into Workbook Connections and removed the old workbook connection and added the new one and clicked Refresh and it gives...

Hi- I have one big pivot table that has a report/page filter by salesperson and then that pivot table is broken down into 15 subsidiary pivot tables by salesperson. Each month I want to mail each salesperson their detail but I do not want them to be able to see each others. I tried going to...

Hi I am trying to sort a protected Excel worksheet. I unlocked the cells in the column I want to sort and then protected the worksheet. I selected "Select unlocked cells" and then selected "sort" before protecting the rest of the worksheet. I can change the numbers in the unlocked column but it...

I must be losing it. In Outlook 2002 I had no problem but how do you customize the Outlook Today page in the 2003 version? Help says to 1. On the Go menu, click Shortcuts. 2. In the Navigation Pane click Outlook Today. 3. On the Outlook Today page, click Customize Outlook Today When I click...

Hi- I exported my Outlook Contact list to Excel and filtered it. I saved the new file. When I use the Mail Merge Wizard in Word, it allows me to select the excel file as the recepient file but then displays a dialog box showing three different Contact tables. No matter which I select, I always...

Hi- Anyone know of a way to link a single cell or a couple of cells in Excel into a Word memo. I can insert a single cell but I can't find a way to link it so that it updates. For example, I want to be able to type a sentence in Word saying Net income is projected to be ____ and then have way...

Hi- I am putting together a class on importing and retrieving data through the use of Excel primarily. I am looking for some sample DBASE or FOXPRO databases that I can show my students how to import. Any idea on where to find some free sample files? Thanks Patricia

Hi- I can enter new data into a spreadsheet and have it automatically plot into the existing chart using the OFfSET function but I can't figure out how to automatically add a new data series into a chart or if that is even possible. I know how to add a data series into a chart but wanted it...

Hi- I am instructor who has been getting a lot of requests to teach and create some Excel macros. Any recommendations on a good reference book or manual for Visual Basic as a starting point. I have some basic programming skills but need something basic to start with as I am very rusty. All...

Hi- I asked this question in the Corporate trainer forum but it doesn't look like anyone has used it in months so I am also posting the message here. I am putting together a workshop on data retrieval tools. It explores basic database concepts and then using both Excel and Access I am going to...

Hi- Doesn't look like this forum gets used much which is too bad. I am putting together a workshop on data retrieval tools. It explores basic database concepts and then using both Excel and Access I am going to show them how to extract data via queries out of an Access database. I am looking for...