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