Background: I have approximately 2,000 - 3 X 5 cards - and 500 - 5 X 8 memo sheets; each card and memo sheet has information I transcribed from daily readings. It may be quotes, phrases that I enjoyed, passages that touched me, or other written matters. Question 1: What would be a good software product I might consider to transcribe these 2,000 card and 500 memo sheets. Question 2. What product might I consider using to record the transcriptions of information. The product should allow for me to move, rearrange, summarize, add to, and or delete information from the 2000 transcribed cards and or 500 memo sheets.

My thoughts to date included possibly using Dragon Naturally Speaking as the transcribing software to which I would transcribe the information into "cells" on a Microsoft Excel worksheet. Although the data could be edited and rearranged, I am not sure this makes the best sense as Excel is not a "Word" type software.

I want to know if there are more appropriate cost effective transcription products available and writing products to transcribe to. The end result with be a hard back book and information sheets for internet distribution either for free or fee. I would appreciate someones experience.

I need an Excel formula to do the following:

If the value in cell H4 is greater than 0,
Search cells AC525 to AC779 to match the number in H4
When a match is found, enter the value from the matched cell immediately to the left of the AC cell (AB) into cell G4.

On an Excel spreadsheet I need to automatically return a value based on a couple of conditions. My formula does not work.

If cell J3 has a date entered and
Cell C3 contains the letter P
Cell D3 will return a value of the date in J3 plus 30 days.

If conditions are not met cell D3 remains blank.

My formula =IF(AND(I3>0,C3="P"), I3+30,"")