Search:

Hi Zeddy

Thanks for all the trouble. You are a star. Code now works 100%

Regards

Howard

Hi Zeddy

Thanks for all your effort. This will help me a great deal

I have attached a full sample of the data to be imported and all the data from this workbook is not being imported.

It...

Hi Zeddy

Thanks for the reply. You can post the results/code when you have the time. There is no urgent rush

Regards

Howard

Hi Steve

Thanks for the reply. The easiest way to resolve this would be to write code to do the following on workbook FA Sample Data.2

1) Check sheets2 onwards (sheets names as pages i.e Page 2...

Hi Zeddy

Thanks for the help. The difficulty is that this file was in PDF and whhen using a PDF converter, there are several sheets and the Net Book value is not in the same column. It would be...

What I need to do is to look up the net Book value in the source workbook (FA sample data.2) based on the asset number in Col C of the destination workbook Fixed Asset Sample.2-2 and place the result...

Thanks for the reply. My Apologies, Only when you replied, I checked the workbook Fixed asset sample.2 and it was the same as FA sample data.2

I uploaded the correct file now. It would be...

I have a workbook called Fixed asset sample.2. I would like a formula or macro to extract the net book value from workbook FA sample data.2 based on the asset number on Col C. The formula or macro...

Is there any good software that anyone can recommend that I can use to improve the performance of my PC which is 4 years old?

Hi Zeddy

Thanks for the reply. Will copy the "Fetch Vat data" button on all the required sheets

Howard

Hi Zeddy

I have resolved the problem. The range name amount2 in the sheet parameters was missing. I may have deleted this in error. I have created the ranhe name and re-tested your macro and it is...

Hi Joe

Thanks for the info

Hi Zeddy

The destination file has multiple sheets, for each month of the year

I created an additional sheet, "Feb-2013" and when selecting the source workbook sheet rz1-br4-source vat...

Hi Zeddy

Thanks for all the effort in developing the code to suit my needs. I really appreciate the help that you have given me

Regards

Howard

Hi Maudibe

See attached sample files

Your assistance in writing the code will be most appreciated

Thanks I have this program. Never thought of using to insert in powerpoint slides

Hi Maudibe

Thanks for the reply. It is different to my earlier post. It would be appreciated if you could assist me

Regards

Howard

Hi Maudibe

Thanks for the help, much appreciated

Regards

Howard

I need a macro to do the following

1) To give option select a workbook workbook in directory c:\my documents
2) To compare the name on the source workbook in Cell B1 to the name in Col B ofn the...

I have two workbooks and would like a macro to copy data from the source work to the destination workbook as follows (macro to be in destination workbook)

1) Source workbook (Browse Assets.xlsx)...

I would like to know if there are freeware programs or fairly prices programs to convert Excel sheets into Powerpoint slides?

Hi Zeddy

Thanks for the help

Good idea to simply and show ageing per category i.e new used wholesale

With regard ro the sumproduct, I had the formula almost correct i.e...

Thanks for the help, much appreciated. Would sumproduct not be easier to use in this instance and if so how do I use this formula?

Hi Zeddy

Attached please find file as requested

Regards

Howard

I have values in Columns B to D and ageing of the data in Col E

I have tried to set up a SUMIF formulas to compute the following

1) The value of the data in Columns B to D where the ageing is 7...