Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text into numerous cells for many different files
This may or may not fall into the Macro category. It is the only thing I am
aware of that can repeat the same job, but not sure if this qualfies. I need to insert the same text into multiple cells for about 250 different Excel spreadsheets. Each sheet is set up the same (columns and rows), but vary in the number of cells that need the text (sometimes 2, sometimes 15). All cells fall under the same 2 columns though. Is there a way to creat a macro for this task? I've done a few macros before, but nothing like this. Is there some other tool I should be looking into? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text into numerous cells for many different files
Are all of the sheets on the same workbook, or are these 255 different
workbooks? "Joshua" wrote: This may or may not fall into the Macro category. It is the only thing I am aware of that can repeat the same job, but not sure if this qualfies. I need to insert the same text into multiple cells for about 250 different Excel spreadsheets. Each sheet is set up the same (columns and rows), but vary in the number of cells that need the text (sometimes 2, sometimes 15). All cells fall under the same 2 columns though. Is there a way to creat a macro for this task? I've done a few macros before, but nothing like this. Is there some other tool I should be looking into? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text into numerous cells for many different files
also, is there a specific condition that will cause entry into the column?
(i.e. - cell A2 is not blank) My thinking, as I'm thinkign all of this is, if all worksheets in one file, and if, say, the driver is the value in column c is not blank, I would select all sheets, then starting with, say, A2, enter: if(C2 <"",Value,"") Then paste down enough rows to cover the longest sheet. This way, if the row doesn't merit a value, it will be left blank. "Sean Timmons" wrote: Are all of the sheets on the same workbook, or are these 255 different workbooks? "Joshua" wrote: This may or may not fall into the Macro category. It is the only thing I am aware of that can repeat the same job, but not sure if this qualfies. I need to insert the same text into multiple cells for about 250 different Excel spreadsheets. Each sheet is set up the same (columns and rows), but vary in the number of cells that need the text (sometimes 2, sometimes 15). All cells fall under the same 2 columns though. Is there a way to creat a macro for this task? I've done a few macros before, but nothing like this. Is there some other tool I should be looking into? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text into numerous cells for many different files
All different workbooks.
Not sure what you mean by a 'specific condition that will cause entry'. Each column has a header cell to identify it with. Each of the cells already has (varying) text and I need to insert one character at the beginning of each cell for both columns. All cells are congruant (no blank cells in between) other than one empty (header only) column between the two. "Sean Timmons" wrote: Are all of the sheets on the same workbook, or are these 255 different workbooks? "Joshua" wrote: This may or may not fall into the Macro category. It is the only thing I am aware of that can repeat the same job, but not sure if this qualfies. I need to insert the same text into multiple cells for about 250 different Excel spreadsheets. Each sheet is set up the same (columns and rows), but vary in the number of cells that need the text (sometimes 2, sometimes 15). All cells fall under the same 2 columns though. Is there a way to creat a macro for this task? I've done a few macros before, but nothing like this. Is there some other tool I should be looking into? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text into numerous cells for many different files
Still looking for help on this.
"Joshua" wrote: All different workbooks. Not sure what you mean by a 'specific condition that will cause entry'. Each column has a header cell to identify it with. Each of the cells already has (varying) text and I need to insert one character at the beginning of each cell for both columns. All cells are congruant (no blank cells in between) other than one empty (header only) column between the two. "Sean Timmons" wrote: Are all of the sheets on the same workbook, or are these 255 different workbooks? "Joshua" wrote: This may or may not fall into the Macro category. It is the only thing I am aware of that can repeat the same job, but not sure if this qualfies. I need to insert the same text into multiple cells for about 250 different Excel spreadsheets. Each sheet is set up the same (columns and rows), but vary in the number of cells that need the text (sometimes 2, sometimes 15). All cells fall under the same 2 columns though. Is there a way to creat a macro for this task? I've done a few macros before, but nothing like this. Is there some other tool I should be looking into? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) |