G'day everyone I have no experience in writing macros for Excel, although I do regularly record and tinker with macros in Word. Please could someone write the following macro for me :-)
Background: I'm a language translator and I need a macro that would solve a problem I have with XLSX files. As you may know, the raw data in an XLSX file is stored in some seemingly random order (usually in the order in which the cells were edited), even though the cells are displayed in Excel in the correct sequence. My translation editor extracts the translatable text from the XLSX file directly (basically to a plain text), which means that I'm forced to translate the content in an order that is different from what it looks like in Excel itself. What would be useful is if the cell reference (worksheet name, row and column name/number) can be included in the actual text of each cell, so that I can see it while translating the individual cells (I can then remove the added text later). Macro: I need a macro that will write the location of each cell to the end of that cell. For example, if the current content of cell B3 in the worksheet "Sheet 1" is "Hello world!", then the macro should change that into "Hello world![[[Sheet 1|B|3]]]" or something like that. This should be done for all cells. I realise that doing this might "break" some cells because they contain formulas, but I don't think that that would matter to me because it is just temporary. The cell reference need not be copied at the end of the cell -- it can also be at the start of the cell. Can anyone help me with this, please? I don't often have this problem, but colleagues of mine encounter it more frequently, and I would like to find a useful solution for them. Thanks Samuel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
