I need some code please!

**Excelski** · 06-28-2017, 10:22 AM

Hi everyone,

I need some code please!

I have a workbook with an ever-growing number of sheets named 100, 101,102 etc etc
In another sheet, sheet 1 I have a list of all these named sheets.

I would like some code that returns the data from A1 in all the named sheets to the respective named sheet number in sheet 1…….. I hope that make sense

As always, any help greatly appreciated!

Thanks
Kevin

**sweep** · 06-28-2017, 10:31 AM

Hi,

assuming that your index sheet has a list of names starting in cell B2, enter this in C2

Formula:

Please Login or Register  to view this content.

and copy down the length of your data.

If VBA is absolutely requried,

Please Login or Register  to view this content.

**Excelski** · 06-28-2017, 11:11 AM

Thank you sweep,

I could do it with a formula, but have been trying to do it with code, and now i know!

Kevin

I need some code please!

LinkBack

Thread Tools

Rate This Thread

Display

I need some code please!

Re: I need some code please!

Re: I need some code please!

Thread Information

Users Browsing this Thread

Similar Threads

Web scraping issue - HTML code scraped in VBA differs from source code in the website

[SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.

[SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code

[SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.

[SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table

[SOLVED] Pick up the Vendor code of a part code from looking the highest Qty of a part code

Bookmarks

Bookmarks

Posting Permissions