Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which can create multiple files out of one Options
Macro which can create multiple files out of onI don't have a code
written for this. I need to build it from scratch. I know how to do basic macro recording (changing font size and date etc). Here is the 1st thing that I need the function to do. 1. Find cells that are between 8000000 and 9000000 range and replace the cells in a column that are in that range with a different name. Creating separate files: I need to delete everything that does not equal to a range for example "PC". When other rows are deleted I need it to create a new file with a name of "PC" and so on... Can someone please help me!! e Options |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which can create multiple files out of one Options
If you don't get any other response, I can help. Will have some time this
weekend if you need help. Reply to this posting. " wrote: Macro which can create multiple files out of onI don't have a code written for this. I need to build it from scratch. I know how to do basic macro recording (changing font size and date etc). Here is the 1st thing that I need the function to do. 1. Find cells that are between 8000000 and 9000000 range and replace the cells in a column that are in that range with a different name. Creating separate files: I need to delete everything that does not equal to a range for example "PC". When other rows are deleted I need it to create a new file with a name of "PC" and so on... Can someone please help me!! e Options |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which can create multiple files out of one Options
On Apr 27, 4:54 pm, Joel wrote:
If you don't get any other response, I can help. Will have some time this weekend if you need help. Reply to this posting. " wrote: Macro which can create multiple files out of onI don't have a code written for this. I need to build it from scratch. I know how to do basic macro recording (changing font size and date etc). Here is the 1st thing that I need the function to do. 1. Find cells that are between 8000000 and 9000000 range and replace the cells in a column that are in that range with a different name. Creating separate files: I need to delete everything that does not equal to a range for example "PC". When other rows are deleted I need it to create a new file with a name of "PC" and so on... Can someone please help me!! e Options- Hide quoted text - - Show quoted text - Hello, No one ever responded back. I need some help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which can create multiple files out of one Options
I have some questions
1. Find cells that are between 8000000 and 9000000 range and replace the cells in a column that are in that range with a different name. Creating separate files: Questiona: A) Which Column? B) Is 8-9 millillion the value 9not row number). C) Do the cell need to be compacted? (eliminating rows and columns)? D) Which column(s) does the data end up in. 2) I need to delete everything that does not equal to a range for example: "PC". When other rows are deleted I need it to create a new file with a name of "PC" and so on... Questions: A) Are the names Ranges declared in worksheet? (not in VBA) 3) Show quoted text - Hide quoted text Question: A) What is quoted Text. Do you mean Text Cells. B) You can only hide Rows or columns? Instead of hiding, can we change background color of cells? Hello, No one ever responded back. I need some help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to split up Excel files that are larger then 65,000 rows Options | Excel Programming | |||
Multiple Files & Tabs Printing Options | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Import multiple files macro can't find files | Excel Programming | |||
looping to create multiple files | Excel Programming |