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.

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...

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...

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","")

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...

When I try to shorten the field in a label report so that one long name doesn't feed onto the next label, it shows as shortened, but still prints out overlapped. Anyone know how to affix the Field Lenght in a Label report to avoid this problem?

I got this tip off a weekly email I get: http://www.exceltip.com:80/st/TipofTheDay/828.html and I typed in EXACTLY what the formula says from the diagram http://www.exceltip.com/images/screenshots/828.gif (except that it is C7 & not C8, I tried both but they got it wrong it is C7 & they say...

when I right click on a cell one of the options is "Pick from List" but how do I create the list to pick from?

I have a macro that changes the format of cells from general to Accounting with 2 decimals. However if my spreadsheet is imported, I can use my macro but still have to F2 every individual cell to actually change the format. Is there any other way to do this.. or can I make a macro that will...

I want a report that gives me a list of employees whos hire date + 90 days is within the current month. I know how to do this by derived field "HIRE DATE + 90 days" & then 2 report variables asking me for the dates I want my derived field to fall between. But I am wondering if I can do it...

=OFFSET($A$1,ROW()*3-1,0) can I use a formula like this one if I am using a different tab & I want every 8th number instead of 3rd & how? it doesn't work correctly just to replace $A$1 with the cell I want to start with (whichi is in a different tab)

if I want column B to read every 7th cell in column A is there a formula I can drag & fill like =(A1)+7Cells?????? does that make sense? in other words: B1=A1 B2=A8 B3=A15 B4=A22 how can I do this other than individually linking each cell?

how do I code a macro to insert 1 row (in correct order) into one tab ("Daily") whenever a set of rows (7 rows) are inserted into a liked tab ("Weekly")?????

Can I create a macro that will insert a row in one tab in the correct order if a set of rows is added in the linked worksheet tab . do I need to describe this better?