IF Statement

D

drvortex

I'll try to explain.

In workbook1 I have an input sheet and year sheet. After filling ou
the sheet, I hit a submit button. This will copy the data into a ne
sheet with a NAME according to a particular cell in the input sheet.
However, I wanted to reference the data in the NEW worksheet to th
year sheet. The problem I'm having is how to reference the new rename
worksheet that was created from the input sheet to the year sheet.
know this doesn't make sense but hope you follow. This probably can'
be done easily. Oh well.

Jaso
 
B

Bob Phillips

If you wan t to do it in worksheet functions, you probably need to store it
in a cell when you create the sheet, and use INDIRECT to reference that
sheet being point to by that cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Array Formula + Indirect Reference 0
How to do an IF statement that copy data based on a partial match 0
Simple Copy to and From Cells With IF statement. 3
Generating Fresh Copies Of an Excel Document 3
copy graph from a Worksheet based on a field in another Worksheet 2
Working on birthday "book" for my wife and having layout/editing trouble 0
Create if partial match then copy and paste data from one cell to another 1
Maybe too hard to do? 2

Top