cell to worksheet

D

douglass

I have two open worksheets. The VBA would copy data from the source
worksheet then paste that information to the target worksheet.

The exact target worksheet name is always in cell
c7 of the source worksheet. So, based on that value, it first locates the
same sheet number in the target Worksheet, then pastes the data.

The source worksheet (tab) name keeps changing and does not always match
precisely the name in cell c7 of that sheet (which does not change)
 
N

Nigel

Use the worksheet codename and remove link to c7 if it never changes. If
also makes the copy operation simpler by referring to the sheet by its
codename.

e.g

Sheets("MyTarget").Range("A1") = MyCodeName.Range("A1")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
VBA Coding Help for Beginner 0
Duplicating worksheet based on range and changing worksheet name 3
Copy cell value from one worksheet to matching worksheet in another workbook 4
Create a dynamic master file 1
Copy varaible no. of rows to another woorkbook 2
Runtime error 438 1
export excel data to access table using ADO 0

Top