MrCheese Posted March 13, 2014 Share Posted March 13, 2014 Hi there, Long time watcher, but this time, I can't find my answer. So in Excel, I have autoit paste a table of information (dates and numbers) which is pasted in a CSV format into an existing worksheet which has pre existing information (earlier dates and numbers). These dates and numbers are more of a data feed. So they are pasted into column B after the earlier data, then this is what I need to happen: * they all need to be selected, and 'text to columns' and then separated based on CSV. * Then Column G-> T are deleted, * column A is filled down from the last formula * all is selected and duplicates removed. Now, I can do this by recording a macro, however, I need to do it across 9 sheets in total which the data is pasted into varying row numbers. Additionally, the data posted tomorrow will be further down the spreadsheet then data pasted today. So, I've been unable to replicate the macro across sheets and data later on. How can I make this happen? Cheers. Mr Cheese Link to comment Share on other sites More sharing options...
MrCheese Posted March 13, 2014 Author Share Posted March 13, 2014 Sorry, I should have made it more clear, the guidance I'm after! So, basically, should I continue to use macro within excel, if so, how can I make it perform how I want to, with a variation on sheet and row. Or, can I autoit script the changes that I speak of in some what of an automated way using the excel UDF Or, should I just do it the long way, with send("!+{down}") sleep(500) send("!+{right}") etc. Thanks. Link to comment Share on other sites More sharing options...
water Posted March 13, 2014 Share Posted March 13, 2014 You can either use the Excel UDF that comes with AutoIt or my rewrite of the UDF. My UDF works with ranges so I think it will help to solve your problem. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
MrCheese Posted March 14, 2014 Author Share Posted March 14, 2014 Ok, so it works with ranges, that change? Are you referring to _excel_rangefind ? What other functions would be useful? How do I do fill downs/ remove duplicates, etc? Thanks Link to comment Share on other sites More sharing options...
water Posted March 14, 2014 Share Posted March 14, 2014 You would need multiple functions from the UDF. _Excel_RangeDelete to delete columns _Excel_RangeWrite to insert data into the Excel sheet etc. Best would be to do it step by step. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now