Hi. I would like to fill cells in a column with consecutive numbers and then, in another workbook, automatically fill the first cell in a column with the next consective number. Is this possible and if so,how?
Thanks
Hi. I would like to fill cells in a column with consecutive numbers and then, in another workbook, automatically fill the first cell in a column with the next consective number. Is this possible and if so,how?
Thanks
in the 2nd workbook, reference the range from the 1st workbook using =max()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That gives me the largest number from the first workbook. is there a way I can automatically fill in the largest number + 1, so that the numbering in the second workbook automatically starts with the next consecuting number?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks