Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Copy of email response:
In that case insert a new column A. In cell A2 type 1 in A3 2. Highlight A2:A3 and drag the fill handle to the bottom of your data. Sort on column B, do the copy and paste. Resort on Column A. Remove Column A. Cheers, Shane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Copy visible cells only | Excel Discussion (Misc queries) | |||
tried using SUBTOTAL function (XL XP) and it doesn't seem to work | New Users to Excel | |||
Paste into Visible Cells Only | Excel Discussion (Misc queries) | |||
Not able to Paste cells | Excel Discussion (Misc queries) |