This question already has answers here: What is the best way to share/distribute Excel macro? [closed]
I am searching for text/strings in an excel sheet provided by the customer. The problem is that sometimes the excel Find function works and sometimes it does not. For eg if the excel sheet looks like
I have a table mileage_registrants which keeps users registration 开发者_JAVA百科data. It has a field department which is NULL for all users now. I want to insert department data from a .xlsx file int
The problem in question centers around one workbook which contains all of my data and breakdowns spread across a ton of worksheets. I\'m trying to get macros set up to copy select sheets to a new work
I have a spreadsheet I used to calculate time spend on projects. I take the weekly timesheets sent to me and I pick out and log the hours spent on a task for a specific person on a specific project.
I am trying to calculate point on a line. I got the points of the edges and one distance between one edge to the point I want to find (which is B).
开发者_如何学编程I am trying to automatically enter 0 and 0% values in blank cells in Excel. I have a report in Excel that gets automatically filled up from SAS. After I save this report, I want the b
I want to get the PlotArea width and height in order to calculate t开发者_JAVA技巧he proportion.
My current scenario is that I have 20 Excel files that need to be populated by running multiple scripts.Currently this is a manual process.I am about to start a small project that should automate most
I am using Excel 2010 to create a list of the top 10 vendors by sales during a specified time period. The catch is that I need to consider only customers that are a member of a particular set. I found
加载中,请稍侯......