Hello, I am very new to using VBA and don't really understand much at the minute.
I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered".
I then obviously want it to paste to the next...
I am struggling to create a macro which will import all files from predefined folder having same prefilx. Kindly refer below for more details:
C2 = ShareDrive link in which i have files
Files Name = Sample 1.pdf, Sample 2.pdf, Sample 3.pdf
I have below code by which i can upload...
Can someone help me with same...
I am using Sumproduct funtion which is as follows:
It uses values from two colums (one is the weight and the other the values 0 and 1)
the formula work fine except if the Values column is BLANK.
How can I...
Need help with vba code that should merge multiple workbooks into one workbook from a folder that the user chooses, but it should only merge the 1st sheet of each workbook.
I found this code only it does half of what I need but I'm clueless about the rest.
Scheme for macro working:
1st - Ask...
I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.
e.q. consider i have a table with
Now i want to dynamically create a custom table...
I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet
i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...
I am wanting to move select data to another existing sheet in my spreadsheet. Any that say "Yes" will need the first column data and the reason (last column) to be brought across to the other sheet. In this case the "Sad" and "Angry" data is not needed on the new sheet for the report.
I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...
I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...
i'm a very new user at excel and forums, so please be patient with me.
I do reading tests, and would like to graph the results, I have a sheet with the name of the student on top with what text being tested on, which i guess will be the title of the chart, i then have the the date tested...
I have values in two columns A and C. I need to write a macro to copy the values in every 11th cell in both columns to a new worksheet. The first value in column A that I would like to copy is in row 32. So the subsequent values are in rows 43,54,65 etc. In column c, the first value...