Here is what I came up with. The macro will color the text in the cell white or black depending...
Please try this as well. Sub Save2PDF() Dim Fname As String Fname = InputBox("Enter file name to save", "Save as...
Here is a simple copy and paste from cell A1 to D1 using vba Sub cpy() Range("A1").Copy Destination:=Range("C1") End Sub
I did not write this code but I think that it may help you. For more information about this code...
Hello Can you upload sample of your workbook?
Hi, Thanks for the reply. I need to find a formula for finding the column number, i can't give a...
Not sure if this will help. When you save your file click Tools>General Options and then click on Always create...
Sheet1 column "A" must have at least 2 rows (Cells A1 and A2) of data for macro to work. Less...
Sorry for the late response, I have a spreadsheet with 11 columns – Column A to Column L. Column A has a date, I would like to have a button that a person presses the button a message will pop up asking to select a date or date range from Column A and then it would copy all data that is the rows relating to that date or date range in column A to column L and copy this into another worksheet.
A message puts up asking to select date so in this example let’s say September 29, 2016, then it would select all the data from each row from column A to Column L relating to September 29, 2016, copy it and input it in another worksheet. If the date input was September 29th and September 30th then everything that is related to these dates would be copied into another worksheet under the last blank row.
Hoping that this is possible thank you again for all your help.
Thank you so much it works great. I really appreciate all your help.
OK I got it to work but it is not exactly what I had in mind and this is my fault for poor explanation. So it should look like this:
WB2 = “Trainingcoursecompleted.xls”
Column A = Names of people starting at row 4 and all names are in Column A
Row 3 = Courses B1 = GIS, C1 =OAS, D1 = XYZ, etc
so say in column A Row 4 the person name is Jane Doe
WB1 = “Training.xls”
Person’s name is in C3
Training Course is in D3
Training course completed I input a “Y” in AD26
Once a “Y” gets inputted or pressing the button designated as “send to Training Completed spreadsheet.
The WB2 workbook would automatically open and put a Y beside the person’s name but under the appropriate Course name.
So it would find the name Jane Doe in Column 1 and the course Name as example “OAS”and put a “Y” under the course name as an example Jane Doe’s name (in this example a “Y” would go in Row 4 column D.
And if the person’s name is not found automatically insert the person name at the end of column A and place a Y under the appropriate Course completed.
The code that you created is very close and I hope that what I envision is possible and again thank you so much for all your help. I am still amazed at what you created and hope that the additional request can be done.
Is it also possible for me to download what you have created. I have tried your first code that you have created and I cannot get it to work and I know it is something that I am doing wrong.
This is great and thank you very much. I was just looking over your code and am wondering if there is a way to modify the code to look for the course name in row 1 for example course GIS is D1, course OAS is E1, course XYZ is F1 (this would be in the training completed.xls workbook)? The persons name would be in one column like you have in your example. So if in Training.xls spreadsheet, they completed course GIS (it would activate the code by pressing on a button ), the code would open “trainingcoursecompleted” search for the person’s name and the course name (GIS) and input a Y in the correct spot. Also if we have a new person that just joined the company and his name was not found in the “trainingcoursecompleted.xls” is it possible to have his name automatically inserted after the last name that is in spreadsheet (trainingcoursecompleted.xls spreadsheet). I am hoping this possible and thank you again for all your help. I am currently trying to learn how to do VBA coding and I am just amazed at the possibilities. Even more amazed at your knowledge