Excel Date Picker
Hello , I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate different date format and make it unique across the document. I was able to get a date picker add-in however this wont work because I am sending to users please see below:
How to Autofill one sheet based on a table made in another sheet.
Hello, I am struggling to find the right formula that will let me fill Sheet 2 Column B based on the value in Column A. In the reference table made in another sheet I have all possible Column A values and the Column B values that match. What is the best formula to use. It will need to see that the A column cell matches the A column cell in the other sheet and then fill the corresponding B,C,D and E column values. But just filling column B is most important. Thank you for any help. I know EXCEL is very powerful and has the ability to do stuff like this. Until then I am copy/pasting values across which when some tables have 45 rows and there's 60 tables is a huge waste of time. Sheet 2 Reference Table
Running Macros on Excel Online
I am trying to run a macro on an excel spreadsheet (online version). I UNDERSTAND I CAN'T CREATE OR EDIT ON ONLINE VERSION, but I should be able to still run them and it is not letting me. I have my onedrive account logged into on the desktop version of excel I am using to edit and create the macros and once I save the file in xlsm (macro enabled) to my onedrive, the macros do not run on my online excel. Any suggestions?Excel Web App - freeze BOTH first row and first column AT THE SAME TIME
RE: MS Excel WEB APP Can someone tell me the secret to freezing at the same time, together, simultaneously the first row and first column in an MS Excel Web App spreadsheet. At this time I can only lock one at a time. I find it hard to believe that you cannot lock both (rows and columns) at the same time on Excel Web App version. Does this mean that no one builds large spreadsheet +50 rows long and +20 columns wide? I am getting a run around from Microsoft to get an answer to a simple and reasonable setting.Excel data uploaded to Virus Total and results returned.
I work with cybersecurity and alerts come in with a ton of hashes for executables. What would you recommend for me if I wanted my column in my excel spreadsheet to go to http://www.virustotal.com/gui/home/search and input each hash and give me the readout of if the file is bad or not. (Usually comes back like 0/67 sources or obviously 20/67 if its bad.)Would this be doable in excel or would I need to make a script for this?
