Posts by trksbc

Hi,

I'm planning to automate PPT generation task from excel data. I want to specify the source excel file, the range in different sheets and copy the selected part to PPT. Please suggest how I can go about it. I have basic knowledge of VBA.

I have attached a sample of the workbook where I'll be specifying the range required to be selected.

Thanks a lot!

Re: Vlookup with Dynamic Value

Hi converteds,

Thanks for your solution. It works out perfectly.

The formula I tried was "=INDEX(A2:E27,COUNTIF(A2:A27,"<"&A34)+1,5)"

I had to use the formula in other workbook hence modified to "=INDEX([req1.xls]Sheet1!$A$2:$E$27,COUNTIF([req1.xls]Sheet1!A2:A27,"<"&A7)+1,5)"

It is giving me correct Week ends for all the dates I tried. Will be always right?

Thanks a lot!

(PS: Please let me know if I need to mark the thread solved in forum)

Hi,

I need to do a Vlookup, which will pick the required details depending on the date.

Work file:

I need to look up Date in column A of My work file with Week end in column A of master table, determine which week end the date falls and pick relevant values as in example (marked in yellow).

Thanks a lot!

Program Steps

The program needs to find words in {} in Template sheet
find relevant column in Data sheet
substitute the data inside {} from the respective column and remove {}
save for all combinations below template

This is something similar to mail merge in word, but data is dynamic.

Thanks a lot in advance.