# Search:

Type: Posts; User: HowardC; Keyword(s):

Page 1 of 20 1

1. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Hi Zeddy Thanks for all the trouble. You are a...

Hi Zeddy

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

Regards

Howard
2. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Hi Zeddy Thanks for all your effort. This will...

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...
3. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Hi Zeddy Thanks for the reply. You can post...

Hi Zeddy

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

Regards

Howard
4. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Hi Steve Thanks for the reply. The easiest way...

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...
5. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Hi Zeddy Thanks for the help. The difficulty...

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...
6. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### What I need to do is to look up the net Book...

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...
7. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Thanks for the reply. My Apologies, Only when you...

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...
8. ## Thread: Formula to extract data based on Asset number

by HowardC
Replies
14
Views
196

### Formula to extract data based on Asset number

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...
9. ## Thread: Software to improve PC performance

by HowardC
Replies
35
Views
2,541

### Software to improve PC performance

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?
10. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Zeddy Thanks for the reply. Will copy the...

Hi Zeddy

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

Howard
11. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Zeddy I have resolved the problem. The...

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...
12. ## Thread: Converting Excel sheets into Powerpoint slides

by HowardC
Replies
5
Views
528

### Hi Joe Thanks for the info

Hi Joe

Thanks for the info
13. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Zeddy The destination file has multiple...

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...
14. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Zeddy Thanks for all the effort in...

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
15. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Maudibe See attached sample files Your...

Hi Maudibe

See attached sample files

Your assistance in writing the code will be most appreciated
16. ## Thread: Converting Excel sheets into Powerpoint slides

by HowardC
Replies
5
Views
528

### Thanks I have this program. Never thought of...

Thanks I have this program. Never thought of using to insert in powerpoint slides
17. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Hi Maudibe Thanks for the reply. It is...

Hi Maudibe

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

Regards

Howard
18. ## Thread: Macro to copy data from specfic Cols in Source workbook

by HowardC
Replies
1
Views
138

### Hi Maudibe Thanks for the help, much...

Hi Maudibe

Thanks for the help, much appreciated

Regards

Howard
19. ## Thread: Macro to open workbook and copy data where name matches

by HowardC
Replies
9
Views
276

### Macro to open workbook and copy data where name matches

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...
20. ## Thread: Macro to copy data from specfic Cols in Source workbook

by HowardC
Replies
1
Views
138

### Macro to copy data from specfic Cols in Source workbook

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)...
21. ## Thread: Converting Excel sheets into Powerpoint slides

by HowardC
Replies
5
Views
528

### Converting Excel sheets into Powerpoint slides

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

by HowardC
Replies
8
Views
192

### Hi Zeddy Thanks for the help Good idea to...

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...

by HowardC
Replies
8
Views
192

### Thanks for the help, much appreciated. Would...

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?

by HowardC
Replies
8
Views
192

### Hi Zeddy Attached please find file as...

Hi Zeddy

Attached please find file as requested

Regards

Howard

by HowardC
Replies
8
Views
192

### Sumif not adding values correcly

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...
Results 1 to 25 of 500
Page 1 of 20 1