...errors and PPT cant refresh the OLE data from XLS file. We manually have to correct the file location for hundrets of datapoints in settings. Goal: I would like to have a macro which has two steps when file is opened: Step 1: Do you want to refresh the data from XLS file? - Yes – Go to step 2 - No – leave everything a it is. Step 2: Let customer
...rows (the amount can vary). I need a macro where I can decide a percentage value and then have that many rows removed RANDOMLY from the file. For example, if I set the random value to 20%, 2000 rows would be RANDOMLY removed. If I set it to 10%, 1000 rows would be RANDOMLY removed and so forth. I need this macro for future use and I need it done today
I have some work, in an Excel spreadsheet.
Create Windows Macro/ Bot Browse, Screenshot and OCR Selected Region Immediate start
Hi, I need a Macro to check if for each "ID" under column E, (Type) "Services" under column B exists. If it does exist, then any other row where Type <> "Services" for that same ID should be deleted. If type "Services" does not exist for that ID, then all rows for that ID should be deleted except one and value under Column C (Value) for that ID...
Hi there, I'm looking for a developer who can piece together a simple script or macro or app to grab data from CSV and post with that data on OfferUp. 1) You must be familiar with OfferUp app. 2) OfferUp App does not provide API. 3) OfferUp App require emulation of real mobile data entry, they do not allow for automation. 4) OfferUp is not a website
I need a Macro to check if for each ID under column E, (Type) "Services" exists, if it does, then any other row that has same ID should be deleted. If no type "Services" exists, then all values under Column C (value) for that ID should be deleted and replaced in one cell (whichever cell for that ID) by the amount that is in one cell in column D (amounts
...match up the number of rows in the Performance Table with the Columns in the input file. Don't import the data and show a warning message when they do not match. The performance rating for the Customer Benefits are included in column A of the input sheet. The rating is at the end of the text string. For example, ?:05-VH should be translated into VH. For
Looking for an experienced Bot Developer to teach me 1 ON 1 (I've basic experience), How to build custom-made bots for web automation processes such as scraping, posting ETC. MUST HAVE PRIOR EXPERIENCE IN BUILDING BOTS FOR WEB IN JS / PYTHON. * Looking for a long-term tutor
Please see attached input spreadsheet and output spreadsheet. - Create new WS "Aggregate" & "Volume" - For each worksheet matching "Data-*" - Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS - Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS - Forward fill cells area matching "...
An Excel spreadsheet on an iphon...spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.