Attachment: LITERATURE-ENGL.xlsm
Hello!
ATTACHED IS THE FILE IN QUESTION!
In short: I need columns from one worksheet, to be sent to replace specific columns in another worksheet by the click of a "Send" button. However the columns in the receiving worksheet aren't in sequence. Also, the columns to be replaced are determined by the "selected month" the user selects in a dropdown menu. By the way, if what I'm asking for is impossible, let me know... maybe you can suggest a different way to get the end result.
First, a clear short explanation... (if it helps)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
User determined months:
SELECTED MONTH result returned in: (Sheet1 "J15")
FOLLOWING MONTH result returned in: (Sheet1 "J16")
SEND BUTTON: (Sheet1 "O19")
HERE IS WHAT THE "SEND" BUTTON NEEDS TO DO:
1. Send values from column 'Pounda' (Sheet1) to replace values in 'P' (Sheet3) SELECTED Month
2. Send values from column 'Stanje' (Sheet1) to replace values in 'Stanje' (Sheet3) SELECTED Month
3. Send values from column 'Ulaz' (Sheet1) to replace values in 'Ulaz' (Sheet3) FOLLOWING Month
4. Delete values from column 'P' (Sheet3) FOLLOWING Month
5. Delete values from column 'Stanje' (Sheet3) FOLLOWING Month
Now for the same explanation, but with details:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
First, let me explain the layout of the worksheets...
(Sheet1): "Inventura"
Here the user identifies the "selected month" using a drop down menu, which returns a result in ("J15") as the number of the month. (i.e. May=5). And automatically calculated result of the "following month" is in ("J16").
The user also enters values in 3 separate columns...
1. Ponuda ("C7:C91")
2. Stanje ("D7:D91")
3. Ulaz ("E7:E91")
The "SEND" button is in ("O19"), that's the one that I need your help with
-----------------------------
(Sheet3): "Arhiva"
This sheet has exactly the same publications listed. And contains information of the entire year. However, it begins with September and ends with August. Each month contains 4 columns of information.
-----------------------------
Now here's what I need help with...
In (Sheet1) "Inventura"
First the user selects a "month" from the dropdown menu ("C3"). Then by clicking the "SEND" button in ("O19") I need all the values from columns ("C7:E91") to be sent over to (Sheet3) "Arhiva" and replace existing values there in a particular way.
Here is one example... First, let's suppose the user chose MAY to be the "selected month"
By clicking "SEND" the values from the column:
'Ponuda' (Sheet1 "C7:C91") is sent to replace values in (Sheet3 "AJ7:AJ91")
'Stanje' (Sheet1 "D7:D91") is sent to replace values in (Sheet3 "AL7:AL91")
'Ulaz' (Sheet1 "E7:E91") is sent to replace values in (Sheet3 "AO7:AO91")
Please note that the months correspond to both sheets. While columns ('Ponuda' and 'Stanje') replace values for MAY in (Sheet3), the column 'Ulaz' actually needs to replace values for JUNE, which is the "following month."
So that's the idea. The two columns ('Ponuda' and 'Stanje') always replace values in the corresponding months... while the 'Ulaz' column, needs to replace values for the "following month's" 'Ulaz' column.
In addition to that, the "SEND" button also needs to delete any values in the other two columns for only the "following month," which would mean JUNE for our example. In other words, all values for JUNE in (Sheet3) columns 'P' ("AN7:AN91" ) and 'Stanje' ("AP7:AP91") need to be deleted.
Reminders
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Keep in mind that there is other code already in the workbook. Also, that (Sheet3) does contain the entire year, but starts with September and goes to August. That means that when August is the "selected month", then the "following month" would be September which is at the very beginning of the worksheet.
I realize that one "SEND" button may not be able to do all this work with just one click. I'm open to suggestions, or perhaps more buttons that the user must click on.
Thank you for your help!!!
Attachment: LITERATURE-ENGL.xlsm
Bookmarks