Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text file out put
Hello all,
New challenge (maybe): I have a need to make a text file in the follow format, STD 001 001 C 00001 0032.10 through STD 001 001 R 00100 0050.91 and STD 001 002 C 00001 0025.00 through STD 001 002 R 00100 0037.72 ect. So, my problem is this: 1) Need to paste and copy data from 1st & 2nd tab to the out put tab), Columns A and B (note: there are more columns that will need to be copied and pasted later). 2) Need to paste and copy data from 4 other tabs to the out put tab, Columns A and B but only if user select from a drop down menu, it will need to know what tab and what column to choose. Example: 1st tab has column A STD 001 001 C 00001 (A1- A102) and B has 0032.10 (B1-B102). Need to copy A1-B102 and paste to out put tab. Then it will copy A1-B102 from the 2nd tab and paste below the data from 1st tab. Both tabs data is static. Now, with a drop down menu, user will be able to select one of the following 4900,4910,4915 or 4920. The data is in tab 4900, tab 4910 ect. The VB code will need to copy the correct tab and data to be paste after the data in the out put tab. And finally, with a drop down menu, user will be able to select one of the following 1900,1910,1915 or 1920 and also needs to chose a state. The data is in tab 1900 1lb, tab 1900 50lb, 1900 100lb. The VB code will need to copy the correct tab and data to be paste after the data in the out put tab and then loop through it all so that all data has been pasted to the out put tab. From there I have a VB code to concatenate the data and out put to a text file. Does this make sense? I can email you what I have if that helps. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text file out put
On Apr 7, 4:06 pm, pgarcia wrote:
Hello all, New challenge (maybe): I have a need to make a text file in the follow format, STD 001 001 C 00001 0032.10 through STD 001 001 R 00100 0050.91 and STD 001 002 C 00001 0025.00 through STD 001 002 R 00100 0037.72 ect. So, my problem is this: 1) Need to paste and copy data from 1st & 2nd tab to the "out put" tab), Columns A and B (note: there are more columns that will need to be copied and pasted later). 2) Need to paste and copy data from 4 other tabs to the "out put" tab, Columns A and B but only if user select from a drop down menu, it will need to know what tab and what column to choose. Example: 1st tab has column A "STD 001 001 C 00001" (A1- A102) and B has "0032.10" (B1-B102). Need to copy A1-B102 and paste to "out put" tab. Then it will copy A1-B102 from the 2nd tab and paste below the data from 1st tab. Both tabs data is static. Now, with a drop down menu, user will be able to select one of the following "4900,4910,4915 or 4920". The data is in tab "4900", tab "4910" ect. The VB code will need to copy the correct tab and data to be paste after the data in the "out put" tab. And finally, with a drop down menu, user will be able to select one of the following "1900,1910,1915 or 1920" and also needs to chose a state. The data is in tab "1900" 1lb, tab "1900" 50lb, "1900" 100lb. The VB code will need to copy the correct tab and data to be paste after the data in the "out put" tab and then loop through it all so that all data has been pasted to the "out put" tab. From there I have a VB code to concatenate the data and out put to a text file. Does this make sense? I can email you what I have if that helps. Thanks See if this helps you at all: http://groups.google.com/group/micro...f3a55de6df113d HTH Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Excel VBA - open text file, replace text, save file? | Excel Programming | |||
importing text file, removing data and outputting new text file | Excel Programming |