Windows 10: Excel Automate tab

Hi, I can't get the 'automate' tab in excel .? in customize ribbon it is checked; Any suggestions? I'm not sure what category to put this under so if it needs moving let me know.

:)

 

Automate tasks with Automate tab - now in Excel for Windows and Mac

Source: https://techcommunity.microsoft.com/...r/ba-p/3705856

 

EXCEL automate download stock prices at end of day

Jimbo:

Didn't you have a thread on this a few months back?

I've never found a fully automated way that works LONG-TERM. I've had a bunch of methods that work for months or a year or two and then fail for reasons beyond my control---typically programming changes at the source site.

I've settled on a NON-automated method. It takes 15 or 20 seconds a day.

I swipe the mouse across what you see below and then paste that swipe directly into cell A1 on a specific Excel tab.

The data is then populated elsewhere in the same Excel file by formula.

It's manual, so it's going to work until and unless Bigcharts disappears or has bad data.....that hasn't happened in the 15 plus years I've been using Bigcharts. All you need is your ticker list.

Screen grab below taken about 5 minutes ago, but I typically grab a couple of hours after the close when all prices are in.

 

Help needed with Excel Attendance Sheet

You use the Data tab, Data validation facility to do this.

If you want a coherent explanation then look in Excel Help. Here's the relevant extract from Excel 2007 Help. Excel 2007 Help - Data Validation.pdf

My example:
- I have written them in what seems to me to be the order of easiest explanation.
- You'd actually set them up in the reverse order - step 3, step 2, step 1.

1 The result - my dropdown list. I select the cell then click on the dropdown arrow that appears next to it.




2 To set this up, select the whole column [or individual cells] where you want the dropdown to appear then click on the Data tab then the Data validation control. You need to
- select In-cell dropdown
- set the Allow entry to List
- in Source, enter the worksheet name & cell range where you have written the allowable entries - you will generally want to use absolute cell references such as those shown [$ in a cell address means absolute and will not vary as you copy the formula all the way down your column - look this up if you are not familiar with it because it needs a bit of getting used to].




3 Write out the list of allowable entries that will appear in your dropdown list.




Job done.

Denis