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

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

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

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

One other option is to upload the file to one of the free file hosting sites
and list the location in your post. That way the file is available to anyone
interested in seeing it.

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

***********
Regards,
Ron

XL2002, WinXP


"Sam Commar" wrote:

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