Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next available row
I have a workbook with 6 worksheets - all the worksheets are related to the
same part numbers but each contains different information. The number of rows on each worsheet varies based on the data requirements. Each data table begins at cell A1 on the respective sheet. I import a file to update these data on the various sheets but sometimes I encounter a new part number that needs to be added to one or more sheets. Presently I go to each sheet to get the row count so I know where the next empty row is. Is there another way to do this without going to each sheet? Thanks |