Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Project
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Project
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
Excel project, need help | Excel Discussion (Misc queries) | |||
Excel project, need help | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Excel Project | Excel Worksheet Functions |