Search:

LindaR · 2013-05-21, 12:52

I can't get my report to group and give me a total at the break. I am used to 2003. I know it is something I just am not doing right in 2007. I have a field "Type of Coverage". I want it to group...

LindaR · 2012-04-17, 05:45

thank you so much. Saved me hours of work.

LindaR · 2012-04-16, 13:42

I need a macro to delete the entire row where there is a 1 in column B. Also, to delete one row above. So where there is a 1 in column B, I need that row deleted and the one above. Any help is...

LindaR · 2011-02-02, 13:01

Can't you just select the summation symbol on the top and hit enter. If you look at the calculation, it uses =subtotal(9,c2:C100) for example

LindaR · 2010-12-03, 07:36

How about a pop-up calendar. The attached spreadsheet describes how to do this in Excel 2003. Not sure about 2007. In the code, you have to format the column to the date format you want.

LindaR · 2010-07-22, 11:55

Right click one of the total lines.
Click on Field Settings
Click None.

LindaR · 2010-06-04, 06:06

I am not that familiar with Outlook. I thought I created a folder under another folder - something like a sub folder. I moved an email to this sub folder but I can't see the folder under the folder...

LindaR · 2010-04-27, 07:21

I am not sure if this is where to ask this and I am not sure this is a Windows XP problem. When I go to Microsoft Office Discussion on the web, the area that displays the discussions is blank. I...

LindaR · 2010-01-28, 14:45

=Date(Mod(A2, 10000),TRUNC(A2 / 1000000), MOD(TRUNC(A2 / 10000), 100))

Copy down

LindaR · 2010-01-28, 10:02

Highlight and Right click the column you want to enter the dates.
Select Format Cells.
On the number tab choose custom and enter in the Type Box 00\/00\/0000.
It looks like a V between the 0s...

LindaR · 2010-01-28, 05:42

This may be too simplistic but have you tried:

Put a + sign in the cell you want the data to appear
Go to the other spreadsheet and highlight the cell that has the data you want
Hit enter
This...

LindaR · 2010-01-27, 10:09

Since it is a zip code and a set number of characters try this:

In a new column put =TEXT(A1,"000000") and copy down.

Then highlight that column and
EDIT
copy
Paste Special
Choose values

LindaR · 2010-01-21, 11:15

I figured out how to prevent the #REF! error from showing. Just in case someone else has this problem.

=IF(ISERROR(SUM(E5,E7,E9,E13,E23,E27))," ",SUM(E5,E7,E9,E13,E23,E27))

LindaR · 2010-01-21, 10:26

Yes, I switched from trying to connect the data using Access. I use Access just to update the first spreadsheet. From that spreadsheet I populate the premade spreadsheet with the breaks, headings...

LindaR · 2010-01-21, 09:47

Yes, the spreadsheet I am linking to is premade . It is set up with calculations, headings and such. I am just updating certain sections with data that changes (monthly). I have linked the data...

LindaR · 2010-01-21, 09:30

I do have overwrite existing cells with new data, clear unused cells but it overwrites the cells and leaves the extra cells there. I have to manually delete them. I am not sure what it does if the...

LindaR · 2010-01-20, 11:04

I have a spreadsheet that I want to connect to a database query. Under Data in Excel, I choose "Import External Data" and connect to the query in Access. My problem is that when I choose the area...

LindaR · 2010-01-20, 05:27

Thanks for the reply. I figured I couldn't do anything in a table and had to create a field in the query to accomodate this. The table had a blank for rep number with unknown in the RVP field. I...

LindaR · 2010-01-19, 13:47

I have a query and I have a table that I am joining to this query by rep number. In the table is a list of rep numbers and a field called RVP that I want to bring into my query. Sometimes on the...

LindaR · 2010-01-14, 05:31