I am new to VBA and I have a folder with approximately 130 xls files, all with unique workbook names and worksheet names.
I would like to create VBA code that allows the user to select the directory folder of the files to copy data from the range C2:J2 from the first worksheet in each of...
I am looking for some VBA code to help me with the problems, it would be great if one can help.
I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere.
I've searched for this and have come close to a solution, but they haven't been quite right.
I used the following but it restricts pasting for the entire sheet
I want to copy the heading and paste it to another sheets with numarical order. that is the heading is worke id 1053 (sheet 01). and i want it copy from 1st page and paste it to sheet 01, sheet 03 ..... at the same time the heading also change with sheet name that sheet 01, sheet 02, sheet...
I'll try to keep this short, but am a newbie to more complicated VBA.
Would love some help and explanation of the logic on creating a macro which does 2 things
1. Looks at a range of data and highlights both the row and the column where a cell has conditional formatting.
Note: The range of...
Not sure if this is a duplicate question but couldn't seem to find it anywhere.
I have the following sample data:
HIST EE STS
Hi, complete beginner with excel VBA here. I have a list of people and their information on columns "A:D". Column "A" consists of the persons first name, "B" consists of their last name, "C" consists of their gender, and "D" consists of their rank. The list starts from "A10" and continues down...
I am new here but i need your help for a excel sheet that i am making.
I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs.
In the first sheet, we can select the City and the weight. I want to show in that same sheet the...
Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated.
I have some good formulas already set on 2 separate sheets that calculate the amount of people toward the manager ID and subtract in another column by total of unexcused from the...
I'm new to VBA and currently working on a project which requires me to regularly copy paste the same range of cells between different sheets.
I have a CommandButton which currently executes the following:
Need help on vb script to automatically copy & paste the value from a calculated field into a new field.
Cell C5 is a calculated field, formula is (=SUM($E$9:$E$60)/C1) This field is calculating % complete.
Cell C6 is also a calculated field, formula is...
I've searched for nearly four days for a starting point to help with this project I have. Many simliar macros have been shared but I am just learning about marcros, so trying to figure out how to write it correctly is beyond me.
Take a list of inventory with inspection dates and...