Sorry, thought I was being specific as heck. I swear I
tried really hard. Anyway: Yes, sheet1 is just a shell
linking to the data that would be pasted to sheet2, etc.
Each segment of sheet1 looks to a set of cells that do not
change (only the data they contain). I'm grateful you
replied as though it was a simple link so I know I'm on
the right track. Thanks bunches!
>-----Original Message-----
>Hi
>
>Your post doesn't give a clue, are you simply rearranging
data (i.e. data
>from Sheet2!C3 is always displayed in cell D2 on Sheet1
etc. as example),
>are you displaying specific data at specific location
(i.e. value of X for
>item Y from Sheet2 is displayed in cell D2 on Sheet1, as
example), or do you
>need to consolidate (sum, count) data from Sheet2 into
Sheet1.
>
>Of course much depends on structure (or missing of it) of
data, exported
>from Lotus. But usually it'll be possible to design
Sheet1 in such a way,
>that when data from Lotus are copied into Sheet2 (NB! No
inserting/deleting
>rows, columns or cells! When something needs to be
deleted, use
>ClearContents, to insert new data use
PasteSpecial.Values), the formulas on
>Sheet1 are displaying wanted report automatically -
without any VBA. For
>more detailed help, we need the layout of data on both
sheets explained - at
>least partially (an example field for every different dat
type, I mean here
>simple links, or lookup values, or sums etc, from Sheet1,
and layout of
>source data for all of those on Sheet2).
>
>
>
>
>Arvi Laanemets
>
>
>"Bonnie" <Hambrick@discussions.microsoft.com> wrote in
message
>news:590501c52418$936a00e0$a601280a@phx.gbl...
>> Hi there! Using E02 on XP. Not a programmer but have
used
>> Access for awhile. However, this project can best be
done
>> in Excel. I can do some code, mainly event procedure
stuff
>> as well as formulas.
>>
>> There are still a few Lotus 1-2-3 files at my company
and
>> this one in particular runs a series of fund return
>> reports that can be printed or pasted into Excel files.
>> (One for each of five commission levels, data kinda
spread
>> out in different cells, cause it looks cute to print.) I
>> also have the Excel file "shell" needed by systems as
the
>> final product. (One worksheet, with five segments for
the
>> commission levels; A1:H77; A122;H198; A243:H319;
>> A364:H440; and A485:H561.)
>>
>> For years this poor dude has been printing the five
>> reports, eyeball comparing and hand correcting
the "shell"
>> file before sending it to systems and I know there's got
>> to be a better way.
>>
>> I think I know what to do but want to verify it in the
>> newsgroups before plowing in just in case there's a
better
>> way I'm not seeing.
>>
>> I'm guessing I recreate the "shell" on a new file on
>> worksheet one and paste in the generated file data to
>> worksheet two. Name my file. Then go to each cell on
>> worksheet one and make it equal the appropriate cell on
>> worksheet two. Since the file spitting out the reports
is
>> Lotus 1-2-3, we don't have to worry about the data being
>> altered in any way because we don't even have technical
>> support for it anymore. And until someone reprograms the
>> whole thing in Excel (could be years), this is what
we've
>> got. Then, each time I paste in new data to worksheet
two,
>> worksheet one is automatically updated, correct? Then I
>> just select, copy and paste special/values, save and
send
>> on it's merry way.
>>
>> Looking forward to hearing from someone. Thanks in
advance
>> for any help or advice! LUV U GUYS!
>>
>>
>
>
>.
>