Search results for query: *

Is it possible to have the page numbers in Sheet 2 of a workbook continue numbering after the end of sheet 1 page numbers? For example: sheet 1 has 50 pages (all numbered automatically in a footer) & I want an auto-footer in Sheet 2 to begin at page 51.. is it possible? Thanks.

Thanks Skip. You ROCK!

I'm wondering if the only way to do this would be a Mail Merge with Word.

I don't believe my form is the ordered list you refer to. When I say 'form' I mean a strategically placed area. For example, say I had the image of a W4 on one tab with a list of employee data on another tab: how would I link the data to show on the W4 and print a new W4 for each employee...

If I have 2 tabs, one a list of data and the 2nd a form with links from the data list: is it possible to print a new form for each line of data? Please let me know if I need to compose my question better. ebisabes

Is it possible to create a macro that would create the same pivot table out of a different set of data? & how do I write/record the macro?

Why are my own emmails being cc'd to me? How do I stop this?

I want a list of all employees with a line for each lien. Right now I have it using 3 Tables: Liens, EE, & Payee info Without any derived fields, for employees with more than one lien, it gives me each payee info under every lien case# (that many times) ADP verified that I can fix this...

THANK YOU!! It WORKED!!

nope. pc

Sub PRKYPEPI() ' ' PRKYPEPI Macro ' Macro recorded 8/1/2007 by Betsy ' ' Keyboard Shortcut: Ctrl+Shift+E ' ActiveWorkbook.SaveAs Filename:="C:\ADP\PCPW\ADPDATA\prkypepi.csv", _ FileFormat:=xlCSVMac, CreateBackup:=False End Sub

If I create a macro to do a "Save as" for an excel file from .xls to .csv, and then import that file into my ADP PC Payroll for Windows it reads with everything as an error even though the macro is exactly what I do manually & the upload has no problems manually. Is this an ADP thing... anyone...

Thanks! the =A1=A2 will just be easier.

If I have a formula I use quite often (or more than one) is there a way to save that particular formula so I don't have to type it in everytime? eg: =if(A1=A2,"oops","")

Thanks! I called Adobe and they said Adobe Professional is the one I'll want. $499... ouch, but it'll do!

If I purchase and install Adobe Acrobat (my boss has 6.0) will this allow me to edit scanned or received PDF documents as though they are word documents.? I often have to edit contracts that must stay in the original format... what program do I use to edit the acutal text of the PDFs?

Does anyone know how I need to format my Payroll Journal Entry ( I Use ADP PCPW) so that I can avoid key entry and just import it into MAS 200? I know it can be done I just can't find out the format layout. Thanks!

If I have a list of contacts all in column A for a cell for each Name, Company, Address Line 1, Line 2, City, State, Zip is there a simple way to convert it to be in another tab as A=Name B=Company C=Add Line 1 D=Line 2 E=City F=State G=Zip???? so that each contact has their own line, is there...

is it possible to take a cell formatted as h:mm or 13:30 and convert it in an adjacent cell to 13.5 ???? I thought it should have been possible with =(RIGHT(A1,2))/60 at least to tell me what the minutes equal as a decimal, but I don't know how the formula cell should be formatted & every way I...

I figured it out!! just in case anyone was wondering, create a dirived field : @LEFT( NAME, 16) where 16 is the number of characters to appear. I can't BELIEVE the people on the Reportsmith Help line couldnt figure this out.