macro that writes on wbook 2 base on wbook 1

[janefo]

I would like to create a macro that writes a sentence in workbook 2 base on numbers of workbook 1.
For example if k24 is not empty in workbook 1 sheet1 then write a sentence in workbook 2 sheet 1 A17, if U24 is not empty either, then write a sentence in workbook2 sheet1 A15.
The sentences are written in workbook 3 sheet1

I am new working with excel files, any help is appreciated.
Thanks,
Jane

 

[bensonsearch]

Hi Jane,

so there are 3 workbooks?

are they all separate files? you dont mean sheet 1-3 of the same file?

also if they are different files are the names the same and stored in the same location always?

and lastly for now, are the sentances to write fixed?

cheers

Bensonsearch

 

[janefo]

Yes, there are 3 separate workbooks, the names are sale(wkbook1), report(wkbook2) and phrases(wkbook3). The sentences are fixed, we should just be able to add more if nedded. They are all store in the same location.
Thank you,
Jane

 

[villy]

How would you know in which cell you will write the sentences?is there a definite pattern?

 

[janefo]

I was thinking to start on A15. Usually there will be one or two sentences, but it could be more (max. of four) depending on how many items are sold (workbook 1).