Excel Help.... please...

I need to link 2 cells, one will have text,  the other numbers.

They are an index and part of a cross referencing system.

For example it will say

Chapter 12 Lemons... next to that will be 8.4 lemon curd, 5.2 lemon meringue pie, 22.1 lemonade.

How do I link the number and text so they move together?   Otherwise the cross referencing will go to pot because there are 1000's of these.

It's a manual (not about lemons though) and the references are the other sections that the person should look at.

If you can help, I'd be grateful.

Cheers

 

 

 

Do you mean that you want cell c to show the combined contents of cells a and b ?

Row and column variables and various combination calcs. Not that difficult.

More importantly, where do you want to end up. Don't get lost in spreadsheet detail.

☝️

“My Excel spreadsheets are filled with tiny exclamation marks.”

And given that many of the people in your industry have the attention span of a gnat Doggers, keep it simple.

Ignoring the useless mumbo jumbo from chambers above...

...and applauding mutters’ outrageously awfully spectacular pun...

doggers it’s hard to know exactly what to do without knowing the structure of your document / what’s driving the changes in numbering but either creating a vlookup or a match function should work. 

You analyse the hell out of it, then present it in everyday terms. If anyone plays silly buggers with the underlying data, you've got  them.

Chambo upon visiting someone else's office:

"Nice office you've got here! I've got a 32-inch plasma in mine...get a document up on that bad boy, and you are seriously looking at that document".

Fun times. You're Finance Director, but the numbers on your systems don't add up. I've run the reports in six different ways and they're all wrong. Your junior people must be entering the data wrong in the first place.

Diplomacy was never my strong point.

What the buggery blazes are you talking about chambers? You are literally talking absolute nonsense 

Doggerz - I'm pretty useless at Excel and can't help, but good luck with it and wot 'ronters sed throughout above.

Chambo - if you know your Excel maybe give some clear, helpful advice to Doggerz on what she needs to do step-by-step in response to her pretty clear and specific OP instead of what seems to be the cryptic posturing nonsense you've posted above?

Mutts should get post (and definitely ROF pun) of the year (yes, I know it's only February, but this shan't be beat) for this:

------

Muttley11 Feb 19 18:26

Lemon entry, dear Watson

Chambo is Swiss Tony AICM£5

 

’listen Muttley. Posting is like making love to a woman. You’ve got to lure her in, compromise her with photos of her father bending one up a Russian tranny, then cook her a chicken Kiev.

Put the footage on YouTube and the jobs a good’n.

Don’t give me chicken pox. I don’t need it. ‘

I’m still selfishly chuckling about lemon entry. 

 

Thing is, it’s a line that goes back years for me. Like ...decades. When I was a kid.  And then, out of nowhere, doggers presents the platform.  On a February Monday evening. I would probably have had to shoot myself if I hadn’t delivered. But now I can die content anyway. 

Sit, Russ...

I'm docking a ROF point for the lack of the "my", btw... ;)

Soz... I'm giving the point back on now 'cos I feel sh1t for pointing it out.

On reflection you might have to face off against 'ronters for the pun title given her genius sublime comeback though.

Chambers11 Feb 19 21:34

ReplyReport |

Fun times. You're Finance Director, but the numbers on your systems don't add up. I've run the reports in six different ways and they're all wrong. Your junior people must be entering the data wrong in the first place.

Diplomacy was never my strong point.

Interesting.  

More importantly, what would General Sir Mike Jackson do in the circumstances?

I think in the trade it's known as a 'Drummond Shout' 

Export it to Word. Word has excellent tools for cross-referencing and producing index pages.

 

It turned out that they were entering data wrongly. So all my fancy Excel charts and diagrams were a bit of a waste of time.

Check the underlying data was kind of my point in a roundabout way.

It's more of a cross referencing table. 

If word would allow that to change without doing the whole fecking things 82,000 times that would be great.  This goes into the business and I get 1000 comments on the basis people MUST contribute.

I tend to use excel because I can link the cells and then move the cells.  I haven't found the way to link the text and numerical cells with another one... it seems to go to pot xx

 

I don’t think Excel is your friend here. Don’t you want to use the index compiler in Word for that? Your trying to use spreadsheet software for what is really more familiar as a desktop publishing exercise. 

I still don’t really understand doggers

where is the source? Is it a word document? When you say you move the cells where are the cells? 

Am assuming you have a contract and what you want is to basically look up every instance of when a reference to “lemons” appears (yes ho Ho mutters lemon entry etc) where is the original text of the doc? Surely not in excel? 

You can definitely look up numbers and text together in excel using vlookup but I’m not sure that will solve your problem. 

TC

The base source is both word and excel and some bespoke programmes.

This is an operational manual that covers a process cradle to grave.

There are about 600 sections in it and each section has 3 parts and supporting documents.

so the index is

"Ah I need to look at Business Interruption"  You go to the index and look up "Section 47.8 Business Interrruption", that has the associated sections with it, so it will be "also consider Section 102 - Notice, Section 141.77 - Payment Mechanism" etc, "Section 28 Contingency Plan" there will be approximately 10 cross references per activity.  Those cross references are on the actual documents, this is a double up process. Some of our facilities operate under 15 to 20 supporting contracts with obligations so the managers need it set out for them.

I can link the 47.8, 102 and 141.77 but I want the text box next to them saying what they are.  If I don't people won't know the trigger.  If I put the text with the number, it buggers up the filters.

This will be added to and changed, so the numbering will change.

Any better?

 

I'd suggest your better off using bookmarks and hyperlinks in word.  That's going to be a very long process indeed though....!

I am using excel for a reason.  The document will be placed in an electronic system that is compatible with Excel.  This is why we use Excel for this process.

This is just a question about linking the cells. 

so if anyone knows the answer to that I'd be grateful.

 

For gawd sake give it to some kid in the office who knows how to use Excel... ...then you can stick to the cerebral stuff.

If the index items are parsed into separate columns and all related cells are on the same row then they are linked...

I think the bigger story here is that Chambo appears to have taken up crystal meth.

Hope someone can help you sort it, Doggerz. Good luck.

Anything that is compat with excel will also be compat with word, that's the beauty of OLE - and they all use the same VBA also, just saying.  Anyway, this sounds like a much larger task than you may have given it the credit of being so yeah, what fluffy says, find an excel dev/whizz and expect some output in about three months IMO.

 

What tecco and fluffy said. The fact you’re asking the question means you’re the wrong person to be doing it given the quantity of data you are talking about. 

You have asked similar questions around excel projects before and no offence like but they always sound a bit like this, that you’re asking the wrong question to start with. 

Not you too Fluffy... sad

I expect the "oh you want to go to X, I wouldn't start from here" from the lawyers.... but not you Fluffy...

 

Just take off and nuke the whole site from orbit, Doggerz - only way to be sure.

(Sorry to be flippant - only other thing I can usefully suggest is maybe seek out a more appropriate forum for suggestions to this particular problem - presume they are out there and lawyers are notoriously sh1te at anything like this in general, and Excel in particular - pretty sure there will be forums out there which could give you the answers you need in relatively short order with people who are happy *and able* to help rather than anything else?)

(Sorry to be flippant - only other thing I can usefully suggest is maybe seek out a more appropriate forum for suggestions to this particular problem - presume they are out there and lawyers are notoriously sh1te at anything like this in general, and Excel in particular - pretty sure there will be forums out there which could give you the answers you need in relatively short order with people who are happy *and able* to help rather than anything else?)

Yes, the question is best on an accountancy website 

BC... you know what... ROF wasn't the only place I asked.  I just wanted to start this last night... so my place was lost.

Sometimes ROF does help with these issues but mainly it's people just giving their opinion.

It is resolved now by one of our financial modellers... but they are really busy with the start of year end so I only ask if I really need.

 

Wasn't criticising, Doggerz - glad it's resolved now!

I know ROF can usually help either on- or off-Board with lots of stuff but can also be frustrating if you have a particular issue to sort in short order and get a certain type of reply... ;)

What are you using to link the numbers? Excel should be able to do the same for text  

Tbh I would write a small macro to deal with this as it sounds large and complex but that’s difficult to advise on how to do over an anonymous Internet forum without seeing how everything is laid out  

Can you pop onto pph and pay someone for a couple of hours to write it for you? 

Ah sorry seen you’ve asked one of your finance guys to sort. Good plan!