Macro or VBA
 

I am dumb, but would like to automatically trim down reports that we
get from our IT dept.

We have to delete redundant columns (A,B,C,D,E,G,H,J,K)from each
report. In other words, the only data we want to view is in F,I,J,P.

Can this done more effciently with a macro or VBA/

Could someone give me an example of either so that I could work from
and learn?

Thank-You

start a new workbook
open one of those report workbooks
record a macro into that new workbook (not the report workbook) when you delete
the columns you don't want.
stop recording

back to that new workbook
save it as a nice name
then when ever you need to delete those columns, you can open this workbook,
then select the report workbook and hit:

tools|macro|macros
and run that recorded macro against the active workbook.

wrote:

I am dumb, but would like to automatically trim down reports that we
get from our IT dept.

We have to delete redundant columns (A,B,C,D,E,G,H,J,K)from each
report. In other words, the only data we want to view is in F,I,J,P.

Can this done more effciently with a macro or VBA/

Could someone give me an example of either so that I could work from
and learn?

Thank-You

--

Dave Peterson

range("A:E").clear
range("G:H").clear
range("J:K").clear
etc

wrote in message
oups.com...
I am dumb, but would like to automatically trim down reports that we
get from our IT dept.

We have to delete redundant columns (A,B,C,D,E,G,H,J,K)from each
report. In other words, the only data we want to view is in F,I,J,P.

Can this done more effciently with a macro or VBA/

Could someone give me an example of either so that I could work from
and learn?

Thank-You

?? J is in both lists ??
--
Gary''s Student


" wrote:

I am dumb, but would like to automatically trim down reports that we
get from our IT dept.

We have to delete redundant columns (A,B,C,D,E,G,H,J,K)from each
report. In other words, the only data we want to view is in F,I,J,P.

Can this done more effciently with a macro or VBA/

Could someone give me an example of either so that I could work from
and learn?

Thank-You