redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
Can somebody please help with some VB code that will carry out following simple task...
step 1 > ask user to input start date
step 2 > ask user to input number value
step 3 > ask user to input end date
step 4 VBA will paste the number value input from step2 every 7 days from the start date input in step1 through to the end date input in step3
The following table gives the desired result when the following are input..
Step 1 > 01APR
Step 2 > 2
Step 3 > 27APR
hope this makes sense and thanks in advance
Can somebody please help with some VB code that will carry out following simple task...
step 1 > ask user to input start date
step 2 > ask user to input number value
step 3 > ask user to input end date
step 4 VBA will paste the number value input from step2 every 7 days from the start date input in step1 through to the end date input in step3
The following table gives the desired result when the following are input..
Step 1 > 01APR
Step 2 > 2
Step 3 > 27APR
01-Apr | 2 |
02-Apr | |
03-Apr | |
04-Apr | |
05-Apr | |
06-Apr | |
07-Apr | |
08-Apr | 2 |
09-Apr | |
10-Apr | |
11-Apr | |
12-Apr | |
13-Apr | |
14-Apr | |
15-Apr | 2 |
16-Apr | |
17-Apr | |
18-Apr | |
19-Apr | |
20-Apr | |
21-Apr | |
22-Apr | 2 |
23-Apr | |
24-Apr | |
25-Apr | |
26-Apr | |
27-Apr | |
hope this makes sense and thanks in advance