put

Sir I have to move the file from one place to another i need the vba to do this i will put the location of that file in the vba code where it is located and where we have to move i will put that in the vba code so plz guide

Hi, I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is. Here is the info for you. Worksheet is called TEST Drop down list is in column B Cells awaiting data are in column C, D, E Table...

Hi is there a way besides using .Formula to say sum all the B6's on the worksheets in a workbook expect for sheet1, and put the results in B6 on sheet1?

I'm using this code to count items on each worksheet in workbook 1. How do alter the code so that this part (ws.Range("C1").Value = cnt) is put into a different workbook? both workbooks have the same sheet names, if that helps. Thanks! Dim ws As Worksheet With Sheet1 Dim x As Long x...

I am still struggling with trying got do this. When I activate my userform, if a cell on the worksheet has a value greater than 0 I wan the checkbox to be checked. Currently if checked when unloading it runs a macro and put data in the cell if it is checked. However if you don't recheck it the...

Hi - I don't have any code for this because i'm not sure where to start. On Workbook1.Sheet1 is a lot of data from column A:O. Workbook2 has sheets with names that correspond to column O on Workbook1.Sheet1. I would like to put the date the procedure is run in column A of each corresponding...

Didn't quite know how to word the title... I keep a spreadsheet of music, albums that have come out every year going back to the 70's. As I listen, i score them. One sheet for each year, column A is the artist, B is the title, C is the score. I'd like to put a worksheet in front of all the...

Hello, I'm trying to get a formula with multiple conditions to work and am having a hard time. Basically: If A1 starts with "ABCD" OR "EFGH", put the value (say, $10) of B1 into cell C1. If A1 starts with anything else, put a zero in cell C1. I've tried combining If, Left and Or but I must be...

Hello, Can you help me with this, I need to put in the result the max "320" https://docs.google.com/spreadsheets...it?usp=sharing

Hi all I've created the this spreadsheet: https://www.dropbox.com/s/y9nykdyne8p04ku/Executive%20PA%20Diploma.xlsx?dl=0 but I need to stop cells relating to the same course from being split when I print the document. I was going to put additional rows between the courses but this...

Hello, I am trying to count cells if they are not blank without including extra rows or columns to do so. I know how to represent if a cell is not blank but I do not know how to count them. Example: In the grid below A1 has my header and A2-A5 has a 1 or it doesnt. B1 has my header and B2-B5...

Hi I am using Windows 10 with Office 2010 I want Excel to open to macro enabled template but where to put? Thanks

Hello everyone, i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture. Thanks for your assistance in advance.

Hello I put the following formula in cell CE3 how to replica in VBA. as i get Appln. Defined Error with Ws .Range("CE3").Formula = "=if(" & "BE3<(R[-2]C[-82]" & "," & "BF3" & "," & "0" & ")" End with i could not move further because of error Regards Samd

i need 00901002409 as 009-01-002-409 with the preceding 0's when i try <colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody> 00901001120 =TEXT(G4,"???-??-???-???") 00901001122...

I put name of them user form name.show will not open the form ty Thomas

Wondering if anyone can help. I want to create a user form with two active x text boxes. In box one you put a number and the second box uses a formula to change the number and display the result. For example put 2 in box one and it shows 100 in box 2. There are many other boxes on the form but...

<tbody> <tbody> M N O P Q R S I put staff no. in here I have a formula in here when it generates sales person name after entering her staff no. in column M - formula is =INDEX('Staff info'!$a$3:$a$22,match($Q2,'Staff Info'!$G$3:$G$22,0)) Formula in here for single sales...

I have looked and can't fine code to do this, I have a folder with pictures in it and I would like to put the names of each picture in the folder in column A, date taken in column B and if the pictures have GPS data for them put the latitude in column C and the longitude in column D, can this...

So let me explain. I have a table with months along the top row, a product in cell A2, and each month I have new data Jan = 20% Feb = 30% Mar = 40% Apr = 32% etc I have a different cell on another worksheet in the workbook that I want to automatically put in the latest value in the year...