added

Hello, I'm a novice in Excel, please help on below situation: From multiple worksheets, within a range of cells I want each cells to be added to a master worksheet. For example, from A1 to A8 in multiple worksheets, I want A1.value in multiple sheets to be added to Master worksheet. and...

I have a button on my spreadsheet that copies a worksheet and pastes it in a new workbook. This is my code: Private Sub cmdCopySheet_Click() Worksheets("home").Unprotect Password:="costings" Dim CopyMonth As String CopyMonth = Range("I13").Value...

Good afternoon everyone, I have a document in which I added some bookmarks in tab1 and in tab2, I added the link to those bookmarks in different cells. The issue I'm having is when I click on the bookmarks, it searches for it in tab1 based on the last active cell in the tab. Is there anyways...

Hi there, I am having some issues with the vba formula below and any help would be appreciated. Sub test1() Dim ws As Worksheet Dim copyRng As Range Dim LR As Long, LC As Long Set ws = Worksheets("Sheet1") With ws LR = .Cells.Find("*"...

I am looking for a way to automatically change the color of a row based on the content in a specific cell. For example: - the default color of any row is white - if content is added to cell A2, the color changes to red - if content is added to cell B2, the color changes to green - if content is...

Hello, I have a workbook includes several macros. The file issupposed to be used in several computers with several users. In order to force users to “enable macros”, I added aworksheet named “open & close”. There is a note in this sheet givesinformation to users to enable macros. I also have a...

Hi , can anyone help me with below query. i have a collection of arrays. and i need to read the values. eg: Dim resColl As New Collection resColl.Add Array(key, Key3("UserName"), Key3("Password")) in above add method i added arrays with 3 elements. and after adding i need to read the...

Hi, I want to create a formula similar to above. For example, if (A1) country = UK, and (B1) accomm = Hotel, then (C1) expenditure (£10) is added to (Z5) total expenditure. This will be used multiple times. Thank you!! D

I am trying to add up certain numbers in each row. So each time 4.4 shows up i want the number to the left of it (can be a different number). At the moment i have INDEX(C5:CN,MATCH($CT$2,C5:CN,0)-1). CT2=4.4 This gives me the number left to the first occurrence of 4.4, but I am trying to get...

I have two tables (Table1 and Table2), each on its own worksheet, that have been added into the data model. I created a third table (Table3) by appending Table 2 to Table 1. I chose "Only Create a Connection" and added the third table directly to the data model. Since the third table doesn't...

Hi all, I have an issue that I hope you can help me with. I have a userform that users fill in to complete, this then emails a notification and populates an excel sheet. This works well, however I need a different userform to pull a row of data. My thoughts would be a combobox that...

I've been looking for a set of macros I could use to put together to keep track of items I order. I want to take the data from one worksheet and mesh it together into a history worksheet on another. Basically to keep track of how many of an item I buy by date and add new part numbers as...

Hi guys, I have a workbook that uses large sets of data ~8000rows and counting, and whenever I close this work book, Excel gives me the "Out of Memory" pop-up, once I click okay it pops up again, and again... The only way to fix it is to close all my workbooks. > I have Formulas that use...

Hi, I declared a variable as dictionary. Wonder if there is a way to check if anything been added to the dictionary. I have the following code but it says that the dictionary is NOT EMPTY. Sub store_Dict() Dim Dict_curUpdate As New Dictionary If Not Dict_curUpdate Is Nothing Then...

Hi guys, Would love to know if what I am trying to do it possible? Breakdown of what I'm looking to do is below. Column D configures the markup percentage based on the value range that Column C falls within. This range is on sheet 2 and contains the min. (A) and max. (B) range, as well as...

Fluff Per your request, I am submitting this request in a new thread. For each of the individual worksheets being analyzed in the array, I'd like to get the total column count. I added a line of code (lcolumn) to the "One week only" macro, that I thought would do this. However, the code is...

Good Morning, I have the working code supplied below but would like an extra piece of code added. This is how it currently works. I use a form to transfer data to a worksheet with the use of pressing the CommandButton1 The worksheet is called DATABASE On the form is TextBox4 were i would enter...

Hi, I have an Access db, containing 1 column which has date information in it. The field is called Added. I also have a field called "Account No". I am wanting to create a query against the Added field to either: - Count all the Account No's where the Added date was Friday to Sunday, if...

Hello, i have the code below where i am tring to add the date into my subject, i have added the date picker in Excel called DtPicker1, but when i have added into the code below it doesnt work and i get an error can you help me please? aEmail.Subject = "Saturday - " & Range("B1").Value & " " &...

I am attempting to set up goal seek, and it keeps finding a negative number, no matter how many different ways I try to set up the formulas. I have added photos so maybe someone could help me? Thanks in advance!!