Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex macro issue
I have a very big spreadsheet which is divided out in job areas€¦there are 20
or so job areas and each job area has a few roles in it (can be between 5-10) or maybe more. This information needs to be copied from this sheet into 20 other sheets (so each job area goes into a new sheet and the sheet is named accordingly), so it might be some sort of IF statement that will recognise if something =that and then copies it from the main sheet into another new sheet which should be renamed by the macro as well. BUT the problem is that the information needs to be copied into the new sheet in a certain way, each new sheet will have a pre-set format and the macro should be used to either create each of the 20 sheets or to just use the macro to duplicate last months sheets and empty the data in it €“ leaving all the formatting and the formulas (if thats possible?!). The copied info needs to be pasted in this formatted file where there are colours separating fields and columns to put in certain things. How the macro will know where to copy from the master sheet into these new sheets is because each new sheet, in column R will normally have the job title in it. So the macro needs to get that job title from the master sheet then put it in the new sheet where it finds the job title. BUT there will be numerous job titles on the new sheet and each one will have formulas and total rows etc (so these bits shouldnt be overwritten by the new info)€¦this might make it difficult for the macro to know where to paste the information and how can I say to paste in these rows in this place when the rows will most likely change by the month. (If it helps I can send you the spreadsheet). I dont really know how to get around this, or even if this is possible. Can anyone please advise? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
Complex lookup issue | Excel Discussion (Misc queries) | |||
Complex Array sorting issue | Excel Worksheet Functions | |||
A somewhat complex (to me at least) Nested IF issue | Excel Worksheet Functions | |||
Help with complex index array issue | Excel Worksheet Functions |