Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Shifting Cells up and down in Excel
Name: Ryan Date: January 30, 2009 at 07:32:17 Pacific OS: Macintosh Subcategory: General
Comment:
I am trying to find a way to shift individual cells in a list up or down. I would like to have one button that moves the cell up and one button that moves the cell down. For example, if the list is in cells A2:A15, I want to be able to select any cell in that range and click the up button and that cell will shift up one cell and the cell above it will replace it so no data is erased it is only move around. I would like it to work the same for shifting down
Summary: hi, I want to add drop down in excel using the macro. my concenpt is as follows. if we select "USA" in cell1,1 then the list of states must pop up in cell1,2 and same way for all countries. ...
Summary: Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm trying to combine them all in one IF statement. Se...
Summary: If you want to *replace* the numbers, I believe you are going to need a macro because Excel can't overwrite an existing value in a cell. For example... Sub ReplaceCellValues() For Each Cell In Range(...
LineChart finding slope i...
