I am trying to come up with a better system for creating and logging gift vouchers at work. I have been attempting to put together a Macro but I am hitting a wall. I do however have some experience with PHP programming and have spotted a few programming similarities already, so I should be able to muddle through. This is my first post on here and I'm totally new to Word, Macros, and Visual Basic programming, so apologies if I don't know the lingo, or if you spot me doing anything completely noobish. I'd like to have it automatically increment one, save it, then put the original number back in.Hello everyone, Right now I open it, increment the number by formula) that would do this for me? Is there some way (macro, VBA, VBA, formula) that would do this for me? Rightclick the Excel icon left of 'File' VBA, yes. Then drag the fill handle down to the cells that based on the helper column value, and all the same cell values have been extracted across multiple worksheets, see screenshot. Note: In above formula: Sheet is the increment tab name, A1 is the helper cell, B9 is the cell reference that you want to extract from other sheets.
0 kommentar(er)
