Adapt WorkSheet Transpose Function to work with separate Workbooks

**coreytroy** · 09-25-2014, 05:00 AM

Please Login or Register  to view this content.

I am trying to adapt the above to work between 2 separate workbooks, but have not sorted the correct syntax.

The CS sheet is in Workbook 1
The PRICES sheet is in Workbook 2

Can some one assist me to adapt this to work between workbooks, and not a simgle workbook as is at the moment?

**romperstomper** · 09-25-2014, 05:07 AM

Just prefix Sheets("PRICES") with the relevant workbook name:

Please Login or Register  to view this content.

for example.

**coreytroy** · 09-25-2014, 05:42 AM

Do I need to add the .xlsx also?
I did try that but without the .xlsx to no avail.

**romperstomper** · 09-25-2014, 06:00 AM

You should always include the file extension.

Adapt WorkSheet Transpose Function to work with separate Workbooks

LinkBack

Thread Tools

Rate This Thread

Display

Adapt WorkSheet Transpose Function to work with separate Workbooks

Re: Adapt WorkSheet Transpose Function to work with separate Workbooks

Re: Adapt WorkSheet Transpose Function to work with separate Workbooks

Re: Adapt WorkSheet Transpose Function to work with separate Workbooks

Thread Information

Users Browsing this Thread

Similar Threads

Combine multiple read-only workbooks into one, each into separate worksheet

separate worksheet data into multiple workbooks

Adapt if lookup query to work with percentages as opposed to numbers

How to Combine Separate Workbooks into One Worksheet

[SOLVED] work with multiple workbooks on separate monitor for 2003 edition

Bookmarks

Bookmarks

Posting Permissions