inserted

Hello, That is my first post here and also first contact with VBA. I have created one basic code, very simple, but, it works :) The name of new client is to be inserted in worksheet 1, "Baza", cell A4. Then, this macro creates new Sheet, the name of this sheet is the same as a name of new...

Hi I'm a newbie trying to update a spreadsheet that has 90 dropdowns, containing the same info: E P P/W PK There are two cells to the right of each dropdown: Time Comments When the user selects PK from a dropdown, I need the time to be inserted into the Time cell i.e 1430,1100 etc and the...

I have another odd formula i'm trying to figure out, but I think its a bit complicated. 1. I want a cell to automatically highlight itself if the following conditions are met. a. If the date is within 3 days of the date inserted or past the date inserted into the cell b. there is no entry in...

Hello all, How do you make a cell or whole selected area/spreadsheet automatically capitalize any inserted text to CAPITAL letters? Thank you. Much appreciated in advance.

Can someone tell me how I could follow a hyperlink that comes from the HYPERLINK() function without clicking on it using the mouse? No VBA solutions that I have found through google have worked for me. Please note that this is different from following an inserted hyperlink. There is no context...

Hello In folder "C:\Pictures" from my pc I Have 3 pictures (first pictures it's called "car" // 2nd pictures "dog" // 3rd pictures "horse") all in format .jpg In an active workbook in sheet1 I have in Cell A1 inserted word car...

I'm looking to have an inserted shape (button) act as a hyperlink to a main excel tab. Ultimately a hyperlink to the first tab. Since the tabs are quite busy, I don't want to cover up, add a row or column to the tab, I'm looking to have a shape act as a button but scroll with the user. I'm...

Hey guys! Long time lurker, just can’t seem to find the solution to my problem. I have a workbook with a sheet that gets pictures inserted into it with text boxes and other notations on top of the photos. Up until now we did all of this manually (insert, resize, send to back, etc). I managed...

I have excel 2010 i have changing rows when a row is inserted. i have 2 tables. is there a way i can have my totals formula to stay the same when a new row is inserted.

Hey Guys, Don't know if this is possible, but I will ask. I have a spreadsheet with hyperlinks in it and want to have the current date inserted into column B cell when cell in column A is clicked. Suggestions?

Right now, I have VBA code that only applies to the entire column B. So my VBA code says Target.Column = 2. I re-named column B "safe". I want my VBA code to always work even if columns are inserted between A and B. Otherwise, the code as it is will always just read column B and not follow...

Good Day All, I have been trying to activate an alert date on excel. I am using Excel 2013. Here is the function I have inserted: =IF(G719<(TODAY()+1),”DUE”,” “) I don’t understand why it is showing as ‘Due’ when my Due Date for Next action plan is empty. Is there something wrong with the...

Hi all, I have the following code to insert a new column: (Code) colLetter = InputBox("Please enter replication factor column:", "Factor column") Columns(colLetter).Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove (/Code) Let's say: colLetter = "M" In the new inserted column, I...

Hi all, having a weird problem here, tried searching on the board to see if it had come up before but couldn't find any reference to it. I have a big spreadsheet set up, and users can add comments to certain cells. When you hover over a cell with a comment, the comment box appears close to the...

Hi folks I'm trying to calculate the number of days between two dates in a Pivot Table. Start Date | End Date (Set as Date fields) I've created a new field and inserted a calculated Field (End-Start) but it keeps returning -43000 numbers Any idea?

Hi all, I'm very new to Excel VBA, and this is my first post - please be gentle :D What I'm trying to do is probably quite simple to you lot, but I can't seem to find the right combination of VBA and formula to get what I need done! I've been searching for hours. ex. I enter data in A1, and I...

Hi im using excel 2010 In my work book i have a inserted an arrow from the insert shape's ive chosen the block arrows section down arrow 4 & Up arrow 5 is it possible that if cell A1=0 then B1 has the down arrow 4 inserted And if A1 value= 1 then the up arrow 5 would be inserted into B1...

Hello. I would like to be able to shift cells down so that the values in two columns align. Currently, I am looking at each row and manually insert - shift cells down to line up the values in each column. I have thousands of rows, so I can easily spend half a day or more doing this. Is there a...

Hallo all, I'm working on a sheet for overtime and need the Weekdays to populate under the 1.5 hours column and the Sundays and public holidays to populate in the 2 hours column. Date inserted, I used a simple IF statement to test =IF(B5="Sunday",G5=F5,"") B5 - where date is inserted G5 -...

Good evening, I am having trouble with a FORECAST formula. This formula works when the cells are hardcoded into the formula and the fotmula is copied across... =FORECAST($B2297,E15:E2296,$B15:$B2296) Now I have a calculated figure which resides in cell A1 and changes when a new row of figures...