I have a template with categories. A1,B1,C1,D1,E1,F1, so on and so on..
i have a worksheet. i am trying to run a macro or something.to pass
data from worksheet into template (their specific categories.) .
without typing cell by cell. trying to use VB editor but im lost.


---
Message posted from http://www.ExcelForum.com/

Djranks wrote:
I have a template with categories. A1,B1,C1,D1,E1,F1, so on and so on..
i have a worksheet. i am trying to run a macro or something.to pass
data from worksheet into template (their specific categories.) .
without typing cell by cell. trying to use VB editor but im lost.


I suggest you start by recording a macro as you carry out the task and
then look at the recorded code.

You will no doubt want to generalise the code in some way, but if you can
post some code in a message here and explain how you want it generalised
we will probably be able to help.

When recording a macro you have a choice between absolute addressing
(good for getting to the right starting point) and relative addressing -
good for reaching a point relative to where you were.

If you are smart in the way you go about the task - using filtering
perhaps, selecting the entire region (Ctrl+*), using Ctrl+Down to reach
the bottom of a column etc. the recorded code may not need too much
change.



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup