tab1

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 Everyone, I'm working with Text and Combo boxes on a Tabstrip in a Userform. I have multiple Tabs on which the user will input data and then click a button to write the data to various worksheets. So far so good. My problem is that because Tabstrips share the same controls I want to reset...

Dear, I use 3rd party-services (IFTTT) to add new incoming e-mails from Gmail on Excel/Onedrive, that feeds the Excel/Desktop: Gmail > IFTTT > Excel Onedrive > Excel Desktop To import the data from Excel/Onedrive into Excel/Desktop first I create a connection and after I use the command “Get...

Good day, I am hoping somebody can help me. I have 2 tabs, as shown below. I am trying to copy column C (Name) from tab2 to column C (Name) on tab1 where columns A (ID) match. Now the above I can do using a vlookup but where I am failing is that it needs to copy the value from the row where...

Hi Guys, I've been stuck on something for a while, hoping somebody can help. I seem to have lost it but would really appreciate some help. I'll try to explain as best as I can. I have 2 sets of data on 2 separate tabs. For instance. Tab1: Name | InHere | Exempt | NotHere Tab2: Name | InHere|...

TAB1 has various data across from column A-J. In Column A, i have a date and in Column J i have the same date plus 7 days with a whole load of other stuff in between. In TAB2, i want to select a month in CELL A1 and have the lines below show the data from TAB1 where the date in Column J falls...

I've been spending 3+ days trying multiple strains of excel formulas to solve my conundrum and need some help. I am trying to populate quantities by location and part number on a separate excel tab. For example: TAB 1: **DATA SAMPLE** A B C # Item...

newbie at VBA I have 2 sheets in my file- sheet1 "tab1" has a dropdown for customer(using a data validation list). this tab1 dropdown cell is named selection for ease in coding. On sheet2 - "tab2" I have pivot with customer as the pivot filter. I need to the set customer value from cell...