excel2010

RE: Office Tenant - Rental Status Sheet Hi I am looking to create a worksheet which works out how much rent is still outstanding for a particular client in an office building. The worksheet should act as a statement of account / rent ledger showing the client the dates they were invoiced,the...

below is sheet No1 & 2: Sheet 2: i would like to Automate excel so that it takes the inspection number from Sheet 1 (yellow cells) and put it in the appropriate location in sheet 2 (Red Cells). For example: 1st yellow cell in sheet 1 is "Floor paint" in the "Entrance". now it...

Hello, I'm having a problem with extracting and paste the filename into another workbook. I have code for: Copy Cell "R19" in "Sheet1", in every workbook in folder "Test3". Paste that value into workbook: "vikt.xlsm", column "W" with: Workbooks("vikt.xlsm").Worksheets("Sheet1").Range("W" &...

Good morning - I have a column of data containing dates that are entered as mm-ddd-yy. I have attempted to convert the format to mm/dd/yyy, but it appears the cell contents are being treated as text, and won't convert properly because Excel doesn't know if the year should be 19XX or 20XX...

Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 parameter values (say in columns "B" to "K"). Now, I have another column say "AA" containing IDs (around 1K) which I'm interested in filtering from...

I've created a userform with a textbox inside with the following words: "I'd like to BOLD and ITALICIZE these words." How could I do that? Thus far I've tried using InkEdit, but the issue I have there is when I attempt to edit the text within the InkEdit box, the InkEdit box disappears. It...

Hi all, I have been trying to get my around around a strange issue I have been having with some of my macros. I was very pleased with myself recently when I got to grips with "For Each Cell in Range" VBA however I have started noticing that sometimes these don't work as expected. For example...

I have data the is in this format 10/1/2015 09:57:49 AM. I need to change it to be 01-OCT-2015 09:57:49 AM. When I try concatenate for the day I get some weird numbers back. Get the same when I try concatenating the time piece. Any help is greatly appreciated.

I created a Userform that prompts the user to enter a proposers name and which disciplines they are proposing on. Each discipline has its own tab(worksheet) and each discipline has its own checkbox in the Userform. I want the userform to add the proposer to each discipline tab that has been...

Hi Folks, I've seen a lot of posts similar to this problem and while I have tried to follow the suggested steps, none seem to be working for me. I'm attempting to copy a small range of formulas, pasting these in the adjacent column as values, then sorting these values alphabetically top down...

Hi, I am currently working on a project where I need to filter out values from a worksheet and copy them to another worksheet. Problem is, the values itself are not fixed and I can only find them via a criteria (repeated for each new value) one row above. I also need to take the date and hour...

I need some help with a bit of code i'm trying to write. I am not very experienced in VBA, I thought a VLookup is what i needed but after thinking about it. I think a Find loop with work even better. There will be a button click on sheet1. The code will need to do the following, in sheet...

Hello - I'm trying to write a formula to hyperlink a cell based on the value of another. So far I have this: =IF(A14=5, HYPERLINK(sheet1!A1, "friendly name"), HYPERLINK(sheet2!A1,"friendly name")) But am getting a "Reference is not valid." error and I can't figure it out what I'm doing wrong...

I have 3 work sheets within a workbook: 'RawSupplier' 'RawBalance' 'DataForMap' I need to compile data from 'RawSupplier' and 'RawBalances' onto 'DataForMap'. The Raw sheets contain customer info. I need all the data from 'RawSupplier' and only one column from 'RawBalances' showing...

hello,, i want to ask, how to add image to excel and put their file name together automatically using macro? i ask this because i must add lot of image and their file name, i'm searching it, but most of them using software, i want to ask HOW TO add image and file name without add-ins or...

Hello! I have a form with many worksheets, and I want to prevent my users from deleting any worksheets. I don't want to protect the worksheet because I want users to be able to rename the tabs as appropriate. Please help! Thank you!

Hello guys,</SPAN> I was wondering: is it possible to link an ActiveX Controls (Combo box) and normal Combo boxes to data in other workbooks? </SPAN> I would prefer to keep the data separated from my “Fill in” workbook (workbook that contains the Combo boxes), because the data will have to be...

im working on a parking visual layout for an airfield. on sheet1 I have an image of the airfield and I would like to show little plane icons over it to indicate what plane is in what parking spot. I would also like to change the textbox value of each instance of the plane icon to show the...

Every 2-3 days, I update a data set and subsequently update pivot tables. The pivot table I am most concerned about has nine rows and two columns. The first column contains the status of our properties (i.e., rented, rehab, turnover) and the second column contains the number of properties that...

I have to compare a small tring in a string. For example, I have two columns that are A and B A B test_BL_pa.txt 1 test_AL_pa.txt 2 test_BL_pa.txt 3 test_CL_pa.txt 4 With input are test_BL,test_AL,test_CL. I want to get the value at...