View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
R1C1 R1C1 is offline
external usenet poster
 
Posts: 33
Default Assistnace with simple Macro

It is not a problem, it is a rule. You may ask if someone is willing to look
at your file. If someone is interested they will let you know, and you can
send it to them.


"Sam Commar" wrote in message
...
Why
Whats the problem with that.
"Don Guillett" wrote in message
...
Please do NOT attach files to this group.

"Sam Commar" wrote in message
...
I have a report in Excel which is a payroll output report. This report
comes
out every 15 days. I need to format this with certain default headers
and if
then statements so as to be able to send it to ADP in their format. I
have the formulas for the if then statements etc. but I am not able to
create a macro for the same. I would be very grateful if someone can
help me
with this.

I have attached the Excel file. The output for payroll is from Coloum A
to F
and I have done the formatting from H to Q. ( which is the way that ADP
needs it)

What I wanted to do is create a macro that will look at the file that
comes
out i.e basically A to F in my attachment ( the rows of data will differ
every output but the columns will remain the same) and format it with
the if
then statements (H2 to Q2) / headers(H1 to Q1) etc. like I have in H to
Q
and
put it on a separate sheet if possible.

I would be really grateful for any help on this.

Thank you
S Commar