out there? I have limited to zero bloody knowledge but I have put a daily nominal roll together that needs to automatically change when I put the following days date in. Is it possible to do? I really need the data to simply drop down one slot whenever a new date is put in appreciate any help .....
peterductati.... its a list that I have to manually alter every day i.e bob drops down one window tuesday then another wednesday and so on but it is a ball ache doing 100 people manually so I really need a way of it being done automatically
You need to use a REFERENCE in Excel to do that. This is where the contents of a cell is linked to the content of another cell. A quick example: In Cell A1, type in today's date. In Cell A2, type the "=" character ... without pressing anything else, move the mouse over cell A1 and click. You should now see that cell A1 has a flashing dotted line around it (called "the selection") and cell A2 changes to "=A1" Now press Enter to save this value. Cell A2 should now show the same value as cell A1. Now change cell A1 to a different date, and cell A2 should also update automatically. There are lots of formulas you can use, to do all sorts of calculations on data using this technique! Another tip is to use the Range Fill feature in Excel. To carry on with our example, click the mouse on cell A2 to highlight (but not edit) that cell. You should see the bold border around cell A2, with a little square in the bottom-right corner. Put the mouse cursor over that little square, so it changes to a black cross (not the usual white cross). Now click-and-hold the mouse button on that little square, and drag the mouse downwards - it will start to highlight (put a grey border around) all the cells you drag it over. Once you've selected a few cells, let go of the mouse - you should now see it has filled these boxes as well! Note that if you click onto one of these boxes, it won't have a formula of "=A1" ... Excel is clever and tries to fill the range you selected with a sequence rather than the same thing. There are ways of telling Excel to reference the same thing each time (select more than one cell before dragging the square), but this should work fine for your example.
BTW, there are loads of free online tutorials for Excel, just google. These range from the basics to some really complicated stuff. There's even YouTube videos so you can follow along and copy what you see on screen.
Yep, it was looking very like a macro to me too, but I've never used them (as I haven't ever had that many repetitive tasks to do). Consequently I am macro-ignorant. Which is annoying.
