I felt I was almost there with the search worksheet but I was wrong
The search takes for ever and the info is being displayed in different columns
At my wits end with this one
Example attached
Assistance appreciated
I felt I was almost there with the search worksheet but I was wrong
The search takes for ever and the info is being displayed in different columns
At my wits end with this one
Example attached
Assistance appreciated
Try this:
F5: =SUM(G:G)Please Login or Register to view this content.
F6: =COUNTA(E:E)-3
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Appreciate the assistance
Thanks
Hi Jerry
i don't understand this line
why not this one ?Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-29-2013 at 09:29 AM.
If solved remember to mark Thread as solved
Before beginning, on the Search sheet we clear all the used rows below the first 8 since the top 8 rows are static headers. My code snippet does that.
Yours would clear column B.
No matter what I do I cannot get this code to work on the test example
I must be doing something wrong
Post your attempt to get it to work and I'll see if I can spot the problem.
Thanks for your response.
I have attached the file including the code
You will not there is a Run time error and the data does not agree with the col headings
e.g. no date etc
Again assistance appreciated
Yes, your macro doesn't work, that's why I replaced it with the one suggested in post #2.
Also, your column A was hidden making the column headers look like they were off. I've unhidden the column A and attached my macro to your button.
Many thanks and appreciate your expertise
I wish I could understand more
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks