I've got some data that I need to write into database which is listed in Excel. For each row I want to do something like this: Let's say we are in 7th row INSERT INTO someTable(colA, colB) values(A7, B7) where colC='C7' (I want to have it in next cell and then copy it to SQL Management Studio)
View 7 Replies
I have a master data sheet with four columns, A, B, C and D
Column A has the primary data and B,C,D has dependent data values;
So when I insert a new cell in Column A with cells Shift Down, I want mandatorily new cells to be inserted in the same row in col B, C and D as well so that data integrity is maintained;
I would like to add a date to one cell (say A6) and have this do two things:
#1) this would add "Closed" to a given cell such a A5.
#2) and this would add a color to a group of cells like A1 through A8.
I am working a project where I need to copy/insert a Row of data onto Sheet 3 if values from Sheet2 are located on Sheet1. Here is my code so far:
Option Explicit
Sub move_rows()
Dim ws As Worksheet
Dim ws1 As Worksheet
[Code].....
I would like to know how to use a VBA code to insert today's date into a specific cell (B9) when any cell in column B (B2:B8) has changed.
View 3 Replies View RelatedI'm trying to write a macro similar to the one found here: here:http://www.techonthenet.com/excel/macros/checkbox.php.
Rather then use a textbox, I would like the cell to display the date when text is inserted in the cell to the left.
ie. I insert text (the letter 'a') in cell E11, and the date appears in cell F11.
I would also like the macro to do this for a range of cells ie. for E11 to F21, then from G11 to H21, then from I11 to J21, all the way to column IV.
I am looking to insert a date in a Cell when another Cell's number has been changed.
I was using If statement as: If(isnumber(f4),TODAY())
but I don't think it is working properly
the cells columns would be, e.g. "Consumables stock" and "date updated".
So if someone changes a number is the "consumables stock" column, date updated column auto-updates with current date. How would I go by in doing this?
I would like to create a cell that will tell me if a dimension has failed.
I have a tolerance that the value must be between and if it is not then i would like a cell that will input an X
There's got to be a way to do this (mail merge style perhaps...) I would like to insert the entry/ies under a heading in a table in one worksheet whenever that heading matches the data entered in a separate worksheet.
Presently I can find no way to do this in Excel.
I have tried =INDIRECT but that will not work.
I have a file name typed into cell C3. I want the formula in cell C4 (C5,C6,C7......) to include the name of the file typed into cell C3. The formula in cell C5 shows what the content should look like.
I want the users to be able to type the file name in Row 3 (C3,D3,E3.......) and have the formulas below them insert the file name and access the information from the files (yes the files can/will be open when we do this).
I need to to have at least twenty different formulas (rows) referencing specific cells in these files.
The formulas would look like this ='["File name from C3"]Audit Information'!$D$35.
I am hoping it may only be a syntax thing and someone here can "show me the way" I have tried &$C$3& with and without quotations with no luck.
Here is the test file. Test3.xlsm
I built a formula that should work, but it's too long so I need to condense it.
I have three columns, column 1 has names, column 2 has a formula.
I have 15 sheets, each with a name that could appear in column 1.
If the cell in column 2, sheet 1 is Bob, I want it to pull H5 from sheet bob. That works as:
=IF(A5="Bob", 'Bob Data'!H4, "Work in Progress")
But if I build that formula for all the possible names, it's too long. Is there a way to make the formula autofill with the name in cell A5
So: =IF(A5="XXXX", 'XXXX'!H4, "Work in Progress")
I have a protected sheet. When someone enters a value in column A, I want a value to be inserted into the corresponding row in column G.
E.g. When I enter date in cell A45, I want the time this date was entered into cell G45
I am trying to build a vba macro that will do a few things.
1. Cut the text from the row I am working on in column A before the word "ACTION:"
2. Insert the text cut from that row into Column B. Now, the same row in column B will probably already have text in it I want to keep. So the macro needs to insert a line to push the old text down a line and then insert the cut text.
3. Make the older text's font in that row smaller, like size 5.
4. Back in column A insert today's date and leave the cursor there to begin typing notes for today.
I also need the text starting at the word "ACTION:" to remain bold.
How to insert the text into B. I know this just copies over it.
Code:
Sub CopySubstring()
Dim Numchars As Long, s As String
Numchars = InStr(1, Range("A1"), "ACTION:", vbTextCompare)
If Numchars 0 Then
cText = Left(Range("A1"), Numchars - 1)
Range("B1").Value = cText
End If
End Sub
I have a same spreadsheet that shows a sample with the expected outcome after the macro is run here: [URL] ........
I have a worksheet that before I print.
I have a macro that inserts a sum at F27 (I also have sums at G27 & H27) prints the worksheet and then after printing clears the contents of F27.
If I was to add in a row and then run this macro of course the sum appears at F27 and my other two sums at now G28 & H28.
My question is there a way that when the "F27" sum is inserted it is somehow tied to the position of the G27 & H27 cells so that all 3 sums will be on the same row.
I can use the MATCH function when i am in excel but i am having trouble getting it to work when i am trying to insert the formula using VBA.
Here is the code i have but it wont even compile........
What I want to do is call a value from a cell of a separate workbook file by just inserting the file name. So basically:
Cell A1: File_Name.xlsx
Cell A2: ='[A1]Sheet1!'$B$2
Such that the formula effectively reads: ='[File_Name.xlsx]Sheet1!'$B$2 , and outputs the value of B2 from Sheet1 of File_Name.
But I keep getting error messages.
When I insert a comment in a cell, my corporate version of Excel displays my employee number. How can Code a cell to populate this employee number.
View 3 Replies View RelatedI would like to be able to insert the value of a cell into a weblink. Here is the link.
http://www.thephonebook.bt.com/publisha.content/en/search/business_by_name/search.publisha?BusinessName=<&Y3&>&Location=&x=51&y=8
The <&Y3&> is were I would like the value of cell y2 to populate.
is there a non VBA way to insert the workbook name in a cell?
View 1 Replies View RelatedI have this code:
[Code] .....
The first change in column K it finds perfectly but then it enters a lot of blank rows and does not put blank rows at the rest of changes in column K.
I'm trying to insert the following formula into cell AA11. For some reason I keep getting a 1004 Runtime Error. I'm assuming there is some type of syntax error. I'm not really sure what I'm doing wrong.
View 6 Replies View RelatedI wish to use an InputBox to select one cell in a row and then insert an entire row at that position. What is the VBA code to do this?
View 2 Replies View RelatedWhat I would like to do is to insert the text "Agent" into the empty cell A# immediately above the block of names if "Agent" isn't already there. I'm having trouble with the syntax... The cell A# won't always be the same as the position of the block of names varies. In this case it's A9.
View 2 Replies View RelatedI have list of URL's (5000+) per country which need to be check whether they are working or broken. I have found this website http://www.seoconsultants.com/tools/headers.asp which solves my purpose but processing 5000+ URL's manually will consume lot of time
So is it possible to have macro which will pick URL from each cell & run it in "URI:" textbox of the above link.
I've a sheet and in row A is a list of tasks to do like:
A1 - Task1
A2 - Task2
A3 - ...
Is it possible in VBA to do this:
A1 - Task1
A2 - Blank cell
A3 - Task3
A4 - Blank Cell
A5 - ....
in other words to input a balnk cell between tasks (text)
I need some VBA code which will insert a value into the cell when clicked.
First click = Value: 1
Second Click = Value: 2
Third Click = Value: "" (BLANK)
Cycle back to first click.
I am currently creating a formula/function to insert a value in once cell into many cells using excel 2003 , for example: cell A1 has a value 100 000 000, and the value is going to be inserted, into B1,C1,D1,E1,F1,G1,H1,I1,J1.Each cell will only have one digit only so B1 will have 1, C1 will have 0, D1 will have 0 and for the rest of the cell will have the same thing instead of whole value.I tried this thing with the MID function and it works as long as the source value cell is 9 digits(filling the cell from the B1toJ1), it became my concern when I changed those value less then 9 digits,say 8 or 5 digits where the cell will receive the value are B1 to F1 if 5 digits or B1 to I1 if 8 digits, the rest of the cells are blank.
Are there any possibilities, solutions if the inserted value can be started from C1 to J1 for 8 digits or F1 to J1 for 5 digits etc (less than 9 digits) instead of B1 to I1 (8 digits) or B1 to F1 for 5 digits?
These are source cells:
('sheet 1'!h14) 26.9% (246/914)
('sheet 1'!h15) 23.4% (314/914)
('sheet 2'!h14) 33.8% (212/577)
I want to insert ONLY the number after the left parentheses and before the slash into sheet 3 same cells and sheet 4 same cells
('sheet 3'!h14) 246
('sheet 3'!h15) 314
('sheet 4'!h14) 212
something like
='sheet 1'!h14(after (before /)...?
I have some data generated from same sample as listed below:
A: Amplitude
Time Time(hours) Y (A1) SD (A1) Y (A2) SD (A2) Y (A3) SD (A3) 3.97 95.28 0.01 0.00 0.01 0.00 0.01 0.00 3.98 95.53 0.01 0.00 0.01 0.00 0.01 0.00 3.99 95.78 0.01 0.00 0.01 0.00 0.01 0.00
B: Beat
Time Time(hours) Y (A1) SD (A1) Y (A2) SD (A2) Y (A3) SD (A3) 3.97 95.28 1.00 0.00 0.01 0.00 0.01 0.00 3.98 95.53 2.00 0.00 0.01 0.00 0.01 0.00 3.99 95.78 3.00 0.00 0.01 0.00 0.01 0.00
Is there any easy macro to combine data under A and B. For example:cut A1 data under B:Beat and insert it after A1 under A:Amplitude; cut A2 data under B:Beat and insert it after A2 under A:Amplitude, et al?
In this hyperlink, I like to change "EUR" to whatever is in cell A2.
Code:
=HYPERLINK("http://finance.yahoo.com/currency-converter/?u#from=QAR;to=AED;amt=1")
