Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can excel do this?
I have 4 worksheets using one as a 'master' sheet. The master sheet includes
one large column of data and several variables that I use for the other two sheets. What I am wanting to do is to take the data from these two sheets and insert them within sheet 4. How can I insert a column from sheet 2 into sheet 4 begining at a particular row. How can I insert a series of columns x 5 rows from sheet 3 to sheet 4 under column that was insertedfrom 2. Maybe I am making this more difficult than it is. My main objective is to take all data(single column on sheet 4) output it as txt file. Then take single column from sheet 2 and output it to same text file (append).Then take the multiple columns (determined by a variable that I put in master sheet) x 5 rows output it to same txt file.This all needs to be done with macro. Text file should have data from sheet 4,sheet 2, and sheet 3. My problem is determining the scope of data in sheets. Any help would be greatly appreciated. Thanks, Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |