Thread: [Solved] How to transfer multiple cells from excel to word by formulas
View Single Post
 
Old 05-19-2009, 12:20 AM
justziggy justziggy is offline Windows XP Office 2007
Novice
  
Join Date: May 2009
Posts: 3
justziggy is on a distinguished road
Default
Quote:
Originally Posted by Bird_FAT View Post
Can you give an example of the rules that need to be followed to allow this to work?

ie:
  1. check all cells in column A for a special character - if found move to step 2.
  2. all text in cell A, AFTER special character goes to bookmark 1 in the document.
  3. text to the left of left of the special character goes to bookmark 2.
  4. text in columns B, C & D go to bookmarks 3, 4 & 5
To make a formula that will take the right details you will need to give specific rules - looking at your image, I'm not sure what the rules are going to be!? Can you clarify? I think that it would make it a bit easier to help you that way!
those numbers are not steps. this is just the text i want to copy from excel file. exp: red number 2 means, where it should be put in word (blue number 2) etc.

i know how to crate excel link. but when i create new row in excel file. i wanna warn the word that it should look 1 row lower where i can put new informations for difretn project.
Reply With Quote