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
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 "...
I need someone to creata python script or excel macro to scrap data
We require a macro for Access that will look at a table called Numbers which contains numbers 1 thru about 100,000 and determines which numbers are missing an places them in a table called Missing Numbers. I have attached a sample .mdb. I placed the first missing number in the table so you can see what’s required.
I get a lot of projects where I need to create complex user forms attached to databases in excel. I also have various types of VBA projects that I need done or excel projects. I need someone that has availability, speaks good English, and is a pro.
Have multiple excel files that need to match/cross reference columns, if matching occurs then it performs a series of pre-fill copy/paste data from another excel. Then if no match, then perform something else. This is multiple reports that will need to connect to each other on a weekly/daily basis and run output based on conditions that are met or not
Request: write a VBA macro that creates a button to duplicate template sheet based on the number of line items, automatically perform calculations depending on input values, create button to add columns for cost inputs, create button to show/hide added cost input columns. Starting workbook with notations is uploaded for reference.
I have two excel documents that that are modified daily into one. I would like a macro workbok that i can use daily to upload the document and format quicker. The colume/tab are the same. The formatting requries color, conditional formatting, and moving cloums around.