I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...