| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i copy data without row numbers?
i have 600 potential payees in an excel spreadsheet. Of these only 20%
receive payment in any one week. By using macros I can produce a worksheet showing all payees paid in any one week, hiding all others. However the resulting spreadsheet still retains the original row numbers as the zero value rows are only hidden. Is there any way that I can have the spreadsheet ignore the original row references so that the first payee is shown in row 1, the seconf in row 2 etc?Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
