Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cgilmore
  • Order by date
  1. cgilmore

    excel inserting and re-naming worksheets using a macro

    ...line. Sub Add_Worksheets_Copy_Data() Dim n As Integer, ShN As String, Cr As String With sheets2 For n = 1 To .Cells.Find(what:="*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row ShN = .Cells(n, 1).Value Cr = .Cells(n, 2).Value...
  2. cgilmore

    excel inserting and re-naming worksheets using a macro

    I assumed I needed to give this macro a name so I named it Sub Add_Worksheets_Copy_Data() at the top before the Dim command line When I run the macro it highlights the above Sub line with yellow. It says Compile Error Expected End Sub. I tried changing the End With to End Sub and then I...
  3. cgilmore

    excel inserting and re-naming worksheets using a macro

    Thank you Skip. I changed that line and now it stops at Sheet2.Activate. Can you help?
  4. cgilmore

    excel inserting and re-naming worksheets using a macro

    Patrick, My source data is on sheet1. I typed the following info into Sheet2: A B WILDER ACCOUNT EVANS ACCOUNT GAMBRELL ACCOUNT On Sheet1 the field I want to autofilter by is Account. I moved The Account information to column A because your formula has a field:=1. I turn...
  5. cgilmore

    excel inserting and re-naming worksheets using a macro

    They want a worksheet for each account and will sort and apply different formulas for each account.
  6. cgilmore

    excel inserting and re-naming worksheets using a macro

    I have Windows XP and Office XP. I have a spreadsheet that we download every month and it will have 22,000 plus rows. I then insert 10 new worksheets and name them for each acct. name such as EFC, OVK, etc. Then I use Data, Filter to pull up the account name and copy these sheets to the...
  7. cgilmore

    Excel Sum if using a Date Range

    Thank you so much. You guys are the MEN!
  8. cgilmore

    Excel Sum if using a Date Range

    ...<=2/28/2005. Eventually I will need to do this for all the months in a huge spreadsheet. I tried changing the formula to =SUMIF(B2:B9,">=1/1/2005*<=1/31/2005",C2:C9) but I get a 0 Then I changed the formula to =SUMIF(B2:B9,">=datevalue(1/1/2005)*<=datevalue(1/31/2005)",C2:C9) and again I...
  9. cgilmore

    Office XP document image writer print driver

    I went to microsoft.com and did a search for eraser2002.exe and eraserxp.exe. Didn't find either one. Only found an eraser2000.exe. Also did a google search for either one.
  10. cgilmore

    Office XP document image writer print driver

    I re-installed office xp and I chose office tools, run all from my computer . Then I checked beneath printers and it is not present.
  11. cgilmore

    Office XP document image writer print driver

    I have Windows XP and we use office xp. On my desktop I have a document image writer print driver which is great because I can save pdf, word, etc. documents as mdi and then use insert file to create a multiple page tif file. However, I don't remember how I installed it. I need to install...
  12. cgilmore

    Excel Freeze Panes Problem Copying from one ss to another.

    I have a fellow employee who has 2 huge spreadsheets. We both use Windows XP and Office XP. She has frozen panes on both spreadsheets so she can see what she is copying. She used window arrange, horizontal, so she could see both ss files. She can't move her cursor around in either file with...
  13. cgilmore

    Set Deleted Records to Off in CR 9

    I have CR 9. I am attaching to Visual Fox Pro Database Tables. If I go into the DB program the programmers have typed in set deleted records to off so no deleted records show up in the reports that they have created. I am getting deleted records in my CR. Does CR have something similar to...
  14. cgilmore

    Duplicate Records

    I teach Crystal Reports 9. Some of our reports will show a record more than once, so I group them and put my formulas in the group footer. One of my students asked why do you see more than one occurrence of a record in the details section. Is it because the same record pulls from the master...
  15. cgilmore

    Counting submissions on a Top N report

    That worked. Thanks for your help!
  16. cgilmore

    Counting submissions on a Top N report

    Thank you. That worked, but I don't understand how it worked. I have used variables before. It looks like grpcnt := grpcnt +1 is assigning a number to each group, correct? Then you are saying if grpcnt <=10 then cntpolicies := cntpolicies + count ({CR_SU.csubmissionid}, {CR_AG.cagntname})...
  17. cgilmore

    Counting submissions on a Top N report

    I use Windows XP, CR 9.0 I have created a report which shows our top 10 agents by submissions. I have the report grouped by Agent Name. In the report footer I have a running total which counted the # of submissions for Bound or reinstated policies. My total is correct and it includes the top...
  18. cgilmore

    Suppress Formula Needed

    That worked. Thanks for your help!
  19. cgilmore

    Suppress Formula Needed

    I am using CR 9 Professional. I am reporting off a Visual Fox Pro database using an ODBC connection. I have my report sorted by state, then lastname, then firstname then ssn. My report contains 8,000 records. I want to only see records where a client has 2 or more DIFFERENT SOCIAL SECURITY...
  20. cgilmore

    Crystal Reports - MS Excel Export format dll error

    Thanks for your idea. I deleted off one of the formulas in the report. Re-exported and it exported all 22,008 records.

Part and Inventory Search

Back
Top