O
Hello Vb masters, I'm trying to do something way over my head, I need serious help.. I would like to make it such that when my user presses a button, the data that they cut and pasted into a worksheet automatically gets cut and pasted into another sheet of in workbook. THere are several references/lookups that must be done though, so that the data is delivered into the right columns and rows in my other worksheet.
To reference what column it must go into I have the first worksheet of my application where the user must select from combo box the "month" and the "week" of the data they are about to copy and paste into worksheet2 The steps are as follows:
1. users pick the month and week from combo boxes on worksheet1
2. they paste data into worksheet2 (the data they paste is from an external source but the first column has fields that match the fields in my other worksheet, worksheet3)
3. they press a button after they finished copying and pasting the data into worksheet 2, and then the data automatically gets cut and paste into it's appropriate place in worksheet3.
for example,
-Let's say I chose "march" and "week1" as my selections from combo boxes on worksheet 1. (this means I'm about to cut and paste the march, week1 data into worksheet2)
-The data I'm cutting and pasting into worksheet2 looks like this:
red 12
blue 23
green 3
-Now the worsheet 3 (where the above data should be cut and pasted to when hitting my button) looks like this:
Jan Feb March
week1 week2 week3 week4 week1 week2 week3 week4 week1 week2
red
blue
yellow
orange
green
-I'm trying to make it so that after they hit the button, worksheet 3 then gets filled out correctly. in this case after hitting the button it should look like this:
Jan Feb March
week1 week2 week3 week4 week1 week2 week3 week4 week1 week2
red 12
blue 23
yellow
orange
green 3
The code needs to reference the month and week to put it into the right columns, and also the code must reference the first column fields to make sure that the correct rows are given the correct data... i.e. there was no orange or yellow data in my input, so I need to make sure that no data gets posted in there...
In worksheet three, I have the months in row 1 (four cells merged though) and the weeks in row 2 (4 cells -4 weeks- for each month)....
so...now how do I get that button to do this??
I'd appreciate any help...
rasd
Hello Vb masters, I'm trying to do something way over my head, I need serious help.. I would like to make it such that when my user presses a button, the data that they cut and pasted into a worksheet automatically gets cut and pasted into another sheet of in workbook. THere are several references/lookups that must be done though, so that the data is delivered into the right columns and rows in my other worksheet.
To reference what column it must go into I have the first worksheet of my application where the user must select from combo box the "month" and the "week" of the data they are about to copy and paste into worksheet2 The steps are as follows:
1. users pick the month and week from combo boxes on worksheet1
2. they paste data into worksheet2 (the data they paste is from an external source but the first column has fields that match the fields in my other worksheet, worksheet3)
3. they press a button after they finished copying and pasting the data into worksheet 2, and then the data automatically gets cut and paste into it's appropriate place in worksheet3.
for example,
-Let's say I chose "march" and "week1" as my selections from combo boxes on worksheet 1. (this means I'm about to cut and paste the march, week1 data into worksheet2)
-The data I'm cutting and pasting into worksheet2 looks like this:
red 12
blue 23
green 3
-Now the worsheet 3 (where the above data should be cut and pasted to when hitting my button) looks like this:
Jan Feb March
week1 week2 week3 week4 week1 week2 week3 week4 week1 week2
red
blue
yellow
orange
green
-I'm trying to make it so that after they hit the button, worksheet 3 then gets filled out correctly. in this case after hitting the button it should look like this:
Jan Feb March
week1 week2 week3 week4 week1 week2 week3 week4 week1 week2
red 12
blue 23
yellow
orange
green 3
The code needs to reference the month and week to put it into the right columns, and also the code must reference the first column fields to make sure that the correct rows are given the correct data... i.e. there was no orange or yellow data in my input, so I need to make sure that no data gets posted in there...
In worksheet three, I have the months in row 1 (four cells merged though) and the weeks in row 2 (4 cells -4 weeks- for each month)....
so...now how do I get that button to do this??
I'd appreciate any help...
rasd