Recent content by ebisabes

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!