Search:

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

Page 1 of 4 1

Search: Search took 0.02 seconds.

by Wordnewby65
Replies
11
Views
728

I am not sure it can be done in a formula. See...

I am not sure it can be done in a formula.
See my last post

If it can I'd be interested to see the solution as well.

Thank you for all your time and effort.

by Wordnewby65
Replies
11
Views
728

OK a few more questions. 1. Are the lists the...

OK a few more questions.

1. Are the lists the same size? No
2. Do you want then extracted to a new position? yes
3. Are you hoping to do this with a Formula Or Macro? formula since I don't know...

by Wordnewby65
Replies
11
Views
728

Do mean extract to a new location or just find...

Do mean extract to a new location or just find out which ones do not have a match?

You can use VLOOKUP with an IF to determine items in list A that are not in list B
But it will not directly...

by Wordnewby65
Replies
11
Views
728

Greetings, I have list A and list B, some...

Greetings,

I have list A and list B, some items in list A are the same as those in list B. How can I extract the ones that do not match?

Thank you.

by Wordnewby65
Replies
4
Views
541

That's so awesome. I did know Sum function can...

That's so awesome. I did know Sum function can do that. Danke very much!

by Wordnewby65
Replies
4
Views
541

Morning Hans, I tried your suggestion and I...

Morning Hans,

I tried your suggestion and I got #VALUE! as the result. Do you know why? =SUM(Mar!D8:Apr!D8)

by Wordnewby65
Replies
4
Views
541

I'm not sure if I'm using the correct formula for...

I'm not sure if I'm using the correct formula for what I need. Each tab has monthly data that represents the number of hours each staff member spent on a project. For my YTD tab, I'm trying to find...
8. Thread: How do you suppress the Personal.xlsb worksheet?

by Wordnewby65
Replies
2
Views
937

Thank you for the million and one times:)

Thank you for the million and one times:)
9. Thread: How do you suppress the Personal.xlsb worksheet?

by Wordnewby65
Replies
2
Views
937

Every time I open any Excel file it will...

Every time I open any Excel file it will automatically default to the Personal.xlsb spreadsheet. How do I remove this?

TIA
10. Thread: Copy and drag problem

by Wordnewby65
Replies
2
Views
455

oh my goodness..I feel stupid. Danke Hans!

oh my goodness..I feel stupid. Danke Hans!
11. Thread: Copy and drag problem

by Wordnewby65
Replies
2
Views
455

I have an Excel file and I wanted to create...

I have an Excel file and I wanted to create another Excel file for a different department but only want certain information to be linked between the file. I've been manually linking one cell (this...
12. Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
711

Thank you all. I was able to fix my problem by...

Thank you all. I was able to fix my problem by placing the cursor on the header of the missing page, select page layout/breaks/page and then update. Thanks again:)
13. Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
972

Yes, it is the right graph. It works for the...

Yes, it is the right graph. It works for the other graphs. This is driving me to drink:) Never the less, thank you for your time. I'll just delete that graph and start over.
14. Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
972

I tried what you suggested. If I just paste then...

I tried what you suggested. If I just paste then I get the curent graph but if I paste special then I get the previous graph...ughhh..this is killing me. I need the graph to be linked. Is this a...
15. Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
972

Thank you Hans.

Thank you Hans.
16. Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
972

I'm not sure If this a Word or an Excel issue. ...

I'm not sure If this a Word or an Excel issue.

I'm trying to copy a graph/chart from Excel and paste special with paste link/Microsoft excel spreadsheet object. After the 4th graph it only will...
17. Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
711

18. Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
711

It does use Heading 1. I'm unable to send an...

It does use Heading 1. I'm unable to send an attachment since that report is large..60 pages. I need to find a way for TOC to differentiate between pages. It almost like Word thinks page 9 and 10 are...
19. Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
711

Could someone tell me why some pages are...

Could someone tell me why some pages are missing/skip from my table of contents and how to fix it? Thank you.

by Wordnewby65
Replies
6
Views
651

Thank you for your explanation. I'll take an...

Thank you for your explanation. I'll take an aspirin now:)

by Wordnewby65
Replies
6
Views
651

would it burn any more of my brain's cells? ...

would it burn any more of my brain's cells? apparently you know I don't have that much left. btw, congratulations on the new Woody's. It looks great but the people behind it that makes it much...

by Wordnewby65
Replies
6
Views
651

The formula works great but I tried to evaluate...

The formula works great but I tried to evaluate your formula but it appears that I need assistance to put them in laymen terms or me?

TIA.

by Wordnewby65
Replies
6
Views
651

I'm trying to find a date formula that would give...

I'm trying to find a date formula that would give me the date of the 2nd Wednesday of each month. I was able to narrow it down to this formula but some dates are correct and some dates are off.
...

by Wordnewby65
Replies
6
Views
608

Re: Query issues (2007)

Thank you..you're awesome! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>