| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with VB/Macro to shift cells
Hello -
I have a basic spreadsheet with the following information. Cells A2:A11 contain basic number valus. Cell A1 is blank. What I would like to accomplish is for a user to enter a value into cell A1 and have that information replace the value in A2 and shift the rest of the values in the column down. I only want to store 10 numbers (ie A2:A11) at a time. Can anyone provide me with the knowledge on how to accomplish this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Delete - Shift Cells UP problem | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| I need to shift cells down only to a point w/o disturbing the bot. | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
