Obtaining next value from a column in another workbook

**larzep** · 03-22-2011, 02:13 AM

Looking for some assistance and help from some of the Excel masters out there.

I am trying to write a macro coding that when clicked on (Button will be labeled "NEW"), it will give me the next number in my template.xls from a string of consecutive numbers in another workbook called master data.xls

It is for a quoting spreadsheet where I have a master spreadsheet with the details of all the quotes done with an allocated quote number. The macro would then allocate me the next available quote number for my template.xls.

I hope that didnt confuse anyone.

Thanks

**pike** · 03-23-2011, 12:53 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Obtaining next value from a column in another workbook

LinkBack

Thread Tools

Rate This Thread

Display

Obtaining next value from a column in another workbook

Re: Obtaining next value from a column in another workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions