| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to accept input and then populate/concatenate this with other
I need assistance with integrating the following within a macro I have.
Ask the user to enter a 4 digit YEAR. Cell AM1 should be populated with the word Start. Cell AN1 should be populated with the word End. Cell AM2 should be populated with 01/01and the 4 digit year entered above. Cell AN2 should be populated with 01/03 and the 4 digit year entered above. Cell AM3 should be populated with 01/04and the 4 digit year entered above. Cell AN3 should be populated with 31/08 and the 4 digit year entered above. Cell AM4 should be populated with 01/09and the 4 digit year entered above. Cell AN4 should be populated with 31/12 and the 4 digit year entered above. All assistance offered gratefully received. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate function should accept cell-ranges | Excel Discussion (Misc queries) | |||
| Can a cell be set to accept input only once? | Excel Worksheet Functions | |||
| Variable input to populate data fields | Excel Discussion (Misc queries) | |||
| Input to populate report worksheet | Excel Worksheet Functions | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Threaded Mode
