View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] animeshhere@gmail.com is offline
external usenet poster
 
Posts: 6
Default Similar to paste special from another workbook

Dear Experts,
I am an user of excel with mediocre knowledge in functions & macros.
However, here is a requriement which is driving me crazy:

1. I have a row of items in an workbook A. I would like to produce
them in a column in workbook B.
2. A can be modified to add more items but, as of now, there will not
be any modification in between the rows- probably.
3. A macro is not preferred, since if somebody does modify the row in
A, information in B would be messed up.

However, if not better alternatives are available, will have to go for
a macro! :-(

Any inputs would be appreciated.

TIA,
~Animesh