Like the title says. i written a code which lets me add sheets and rename them accordingly. But since i changed something yesterday (i dont know what exactly) it just doesnt run properly anymore.
that is the code:
I currently have this formula:
Right now the cell is showing a blank cell.
I then have another cell that links to this cell through this formula:
This cell also shows blank, because the first cell is blank.
I then have a third and final cell with this formula:
i am new on this forum and really would like to tell you are genius!!!! i tried to do it for my excel file with all the inputs inside this forum but unfortunately i am not good enough. So, my file is an excel file with 11 worksheets. I would like a pop up message telling me when i open...
Dear All Master,
I want to extract table data in html file in excel with vba code. I give the html file and excel output the link.
Link file : VBA EXTRACT TABLE HTML TO EXCEL - Google Drive
Please give me a solution.
I am looking for a VBA code to reconcile two data sets in Sheet1 and Sheet2 (See attached report). Looking for qty differences between both sheets and identifying if a column A, B or C and have any discrepancies. Can anyone help?
Thank you in advance!
My laboratory is capable of running 20+ different analyses, and we get contracts from about the same 15 companies to do a combination of these analyses. I created an Excel spread sheet to keep track of the work as it comes in, where columns are the 20 different analyses we can run, and rows are...
Dear All master,
I want the vba code to copy over entire folders and sub folders very fast.
The vba code below can only be in one folder so if there is, I can modify the vba code to my liking and also I want the process to be very fast.
Dear All master,
I just want the file name in column c and the extension in column d.
The result I want is marked in yellow.
this is my link : result.xlsm
Dim MyPath As String, MyFolderName As String, MyFileName As String
Dear All master,
Please help with vba code, I want input range with inputbox and output range with inputbox.
The data is on the db sheet in column E & F which I marked in yellow and the results
I want are in the results sheet in columns A, B, C. I want a very fast vba code because the data...
I am very new to VBA and am stuck trying to edit code I already have written. Essentially, the code I have (below) was intended to loop through multiple files in a folder and pull certain data columns in from a specific worksheet. This worked fine for its original purpose, but was only...
I am currently managing a stock tracking file, which is edited manually to a large extent.
Currently, the four significant columns look like this:
Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...
I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email.
This works perfectly fine when I do it...
Please help me with VBA code.
as I am stucked in a situation where i need to select the multiple items from drop down list available on web page, we have to select the items from list only as we are doing on Userform Listbox Control.
Below is sample website where you can see the checkboxes...
I would like to ask a help regarding vba code that can auto hide a certain column in each tab..for example Column C1 = I want to hide all that is under C1..
so basically i have a certain name in row1 that i want to auto hide in each tab
Just wanted to ask for a help related to scraping of data from the URL.
I have previously used the following script (function) to extract Article/website title from the URL.
Now, however, I need to extract the date of issue; e.g. when the article was published. Could you please help...
Need help here on adding new name + existing name in tabs/sheets. I am looking for a piece of code that can help me with my work.
I want to add new set of numbers on the existing tabs.
for example project ID is 2214 : (this are may tab names)
After the code runs i...
I have a set of data which can change via formulas. To reduce the amount information the user is looking at, I wanted to hide the rows with a zero balance.
I went to test the below VBA code but it was taking so long, I had to stop it. As you can see, there's over 4,000 rows. Since...
I'm not sure how to go about writing this VBA code. Can someone help me please?
I would like cell M10 to change from True to False and False to True when the VBA Code is run.
So if M10 = True return False, if M10 = False return True
So I am using a pivot table and one of my rows contains quite a lot of wording.
After I select from the filter which option I want, I go to the row that contains the long wording and edit the wording at the top. Then, when I'm done typing it out, it shortens it to so many charaters (I'm assuming...