# Search:

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

Page 1 of 20 1

1. ## Thread: Copying specific account numers and values

by HowardC
Replies
5
Views
93

### Thanks for the help , much appreciated

Thanks for the help , much appreciated

by HowardC
Replies
1
Views
51

### [SOLVED] Just to let you know that I resolved the problem...

Just to let you know that I resolved the problem

A28 =SUM(SUMIFS(J:J,K:K,A28),(L:L,B28))

by HowardC
Replies
1
Views
51

### [SOLVED] Formula Problem

I have tried to set up formula to add various categories in Cols K & L based on values in Col J and criteria in A28 onwards. I am using Excel 2010

It would be appreciated if someone could assist
4. ## Thread: Copying specific account numers and values

by HowardC
Replies
5
Views
93

I would like to set up a formula to give add the totals in Col J, for the following categories

Expense Input
Internal Internal
Output Sales

See Sample Data attached
5. ## Thread: Copying specific account numers and values

by HowardC
Replies
5
Views
93

### Thanks for the help. Will be careful with...

Thanks for the help. Will be careful with explanations
6. ## Thread: Copying specific account numers and values

by HowardC
Replies
5
Views
93

### Copying specific account numers and values

I have account numbers and values in Cols A & B respectively on sheet Data

I would like to extract all the account numbers one row above 125915 and its value in Col B to Sheet "Input Vat" and all...
7. ## Thread: Extracting unique numbers

by HowardC
Replies
8
Views
131

### Thanks for the help. Code works perfect

Thanks for the help. Code works perfect
8. ## Thread: Extracting unique numbers

by HowardC
Replies
8
Views
131

### Thanks for the help. We are close to resolving...

Thanks for the help. We are close to resolving the problem

I have attached three files

1) Extract Files Raw Data
2) Extract files Manual Extraction -this is what the file should look like...
9. ## Thread: Extracting unique numbers

by HowardC
Replies
8
Views
131

### Thanks for the reply. I am using Excel 2010. Your...

Thanks for the reply. I am using Excel 2010. Your guess is 100% spot on.

I have managed to resolve the other problem. Thanks for enquiring
10. ## Thread: Extracting unique numbers

by HowardC
Replies
8
Views
131

### Extracting unique numbers

I have a spreadsheet that contains account number in Col A with corresdponding numbers in Col B. Some of the account numbers in Col A may appear several times, but the numbers in Col B are unique.
...
11. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

Thanks for the reply, Never made mention of the version. I'm using Office 2010
12. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

### Thanks for the help. It now comes up with error...

Thanks for the help. It now comes up with error code 445, object does not support this action

The folowing code is highlighted

With Application.FileSearch
13. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

### Thanks for the help My apologies. I had to...

Thanks for the help

My apologies. I had to leave in a hurry to go to a function and uploaded the workbook not realising at the time that the workbook Macros were password protected. I have now...
14. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

### Thanks for the reply. I agree that it is...

I agree that it is easier to have a macro open up the files one by one. Once the file is open the data needs to be refreshed (See Refresh button) and updated with the...
15. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

### I want to open all workbooks in c:\pull and well...

I want to open all workbooks in c:\pull and well and its the sub-folders where its contains in the name "ACCNTS (P)" for eg BR1 ACCNTS (P) using a macro

I will then update these one at a time
16. ## Thread: Macro to open up specified Files in Directory and Sub-directory

by HowardC
Replies
14
Views
376

### Thanks for the reply. I am looking to open up all...

Thanks for the reply. I am looking to open up all files in c:\pull and its sub-foldfers for eg c:\pull\tbbr1 where there are files that contain the name accnts (p)
17. ## Thread: Utility to ensure memory utilitised efficiently

by HowardC
Replies
5
Views
224

### Hi Guys Thanks for the info- most appreciated

Hi Guys

Thanks for the info- most appreciated

by HowardC
Replies
1
Views
76

### Library

Is there a way to increase the number files in the Library (using Windows 7) for easy access?. I have tried to include a folder but the system wont allow any more files to appear in the library
19. ## Thread: Temperature on Calendar

by HowardC
Replies
4
Views
133

### Hi Guys Thanks for the help. I have now...

Hi Guys

Thanks for the help. I have now changed my setting to celcius
20. ## Thread: Opening up files in folder and sub-folder

by HowardC
Replies
10
Views
256

### Hi Martin Thanks very much for your...

Hi Martin

Thanks very much for your constructive feedback. I will make use of a professional programmer to assist me on this one. I'm getting very close to getting the
result I want , but just...
21. ## Thread: Temperature on Calendar

by HowardC
Replies
4
Views
133

### Temperature on Calendar

I have the temperature in Farenheit that appears at the top on my Calendar in Outlook 2013. I would like to know how to change this to Celcius
22. ## Thread: Opening up files in folder and sub-folder

by HowardC
Replies
10
Views
256

### Hi RG I think that the code would have to...

Hi RG

I think that the code would have to include a variable to declare the subfolder and then set the sub-folder something along this code below, which needs to be tweaked

Sub Open_Files()...
23. ## Thread: Opening up files in folder and sub-folder

by HowardC
Replies
10
Views
256

### Hi RG Have resolved part of the problem. If I...

Hi RG

Have resolved part of the problem. If I copy the files into the pull directory, and then run the macro, then the xls workbooks open. What I need is for all the workbooks containing ACCNTS...
24. ## Thread: Opening up files in folder and sub-folder

by HowardC
Replies
10
Views
256

### Hi RG Still can't get it right. Have attached...

Hi RG

Still can't get it right. Have attached workbook to up files in C:\pull as well as subfolder for eg Pull\TBBR1 as well as file to be opened

It would be appreciated if you could test and...
25. ## Thread: Opening up files in folder and sub-folder

by HowardC
Replies
10
Views
256

### Hi RG When running your macro, I get run time...

Hi RG

When running your macro, I get run time error "cannot find C:\pull\file name.xls .... and the code below was highlighted

Workbooks.Open zFSpec

What I need to do is to open up...
Results 1 to 25 of 500
Page 1 of 20 1