i currently have a file that after 10 days of a completion date the history move to the 2nd sheet. the problem i'm having is that the history overwrites the data and i want all the data on the 2nd sheet to stay and keep.
Super easy project. For the 2 sheets labeled "Purchase Letter -Peo" and "Purchase Letter - QC", create a macro on each sheet that prints all the groups individually. Cell A2 needs to change each time. The value in A2 goes: 1, print, 2, print, 3, print....and on until the end of the list. Please ask questions before bidding. Again, this should
...for my product to be sponsored at - and the yearly calendar is a simple macro coding where you put the events on a box on the right side and the dates on the calendar get highlighted. However, now the dates get highlighted only with blue color for the one blue box that the macro code includes. I need help to create new boxes to better categorize my
Hi, I'm looking for some macro code to create a report from a table of data. Currently, the table lists out transactions with a unique value in column A. What the macro should do is: (i) look through column A, and insert a row when it comes to a new value. (ii) it should then put in column a of the blank row the value of the cell above, and the
You previously created ASIN List Update V1. It takes several columns of data and turns them into multiple rows, but also attaches the 'brand' associated with the ASIN. I would like your help in automating several additional steps of my use of this file. It's probably easiest to show you a demo over video chat.
Need 3 files with macro excel forms for ques/ans/ explanation for answers/summary points/reference. 1. MCQ questions 2. Cases and upto 6 MCQ ques/ans per case 3. same as 2. but upto 8 MCQ ques/ans per case Be able to convert the above in a table format using macro functionality. please provide samples of excel macro forms so I can provide feedback
I am sharing a excel sheet Task (1-) Data for task 1 Create macro for expected result for data 1 when we take entry of date range "deldate" and click on macro button then it pull the related information from sheet "Data for task 1" Expected result for task 1:---- (a-) Yellow column is important for result... (b-) this is example of jobsite 1
...can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a couple
...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
Create Windows Macro/ Bot Browse, Screenshot and OCR Selected Region Immediate start