capture

Hi All expert, Can I check with you.. As I have a Tools booking system. However, notice, people book already and then unbook later. So I want to track who double click the cell to unbook. How? I intend to record down the action that the user did in the form. Now I can record down the user name...

How do I attach a screen capture image of a worksheet? it might help in explaining problems encountered. many thanks

Hi, Is there a formula I can use to pick up/return all matches when a Vlookup is used rather than just the first correct match. If I have data in column A and B, and 4 matches for the identifier on column A how can I capture all 4 matches?. Note the matches are email addresses....so column A is...

Hi everyone! I need some help on excel here... Cell B2 - Manual entry of class start time Cell A4 - Scan in ID (skips to next row A5 after A4 is populated and so on). if ID is already scanned before (i.e Entry Captured), it will go to the cell in column A with correct ID to populate the next...

Hello, I'm having an issue trying to run an index and match formula to capture costs incurred during a week, say 07-Jan-18 and then summarising these into "Jan-18". I've tried something similar with non-date data and I can get index and match to work but not with dates...

Hi All, I have a range of cells that are formula driven to capture values from a live feed, the values will change again within a matter of seconds and I want to capture the history. I'm trying to work out how I would convert cells in a range that are not blank into value to stop them from...

Is there a way, with VBA, to capture the tab someone is navigating to? I would like to capture the navigation request, run some code based on the tab requested, then navigate to the tab. Thanks in advance for any help. -Dan

Hi, Is there any way in VBA to capture the Index of the selected bar in a bar graph. My intention is User will select one bar and run a macro which will take the Index as input and accordingly perform its activity. Any help is much appreciated. - Xenaa

Hi, I am using excel 2010, and want to get the color integer value. I tried using Dim colornumber As Integer Dim c1 as Range Set c1 = Range("A1") colornumber1 = c1.Interior.ColorIndex But the problem is that "grey" has a "2" value and so does the white space, so it doesn't capture all the...

is this even possible > click a command button which does a screen grab and saves to a new sheet - tab labelled as the time - time capture taken want a history so potential for a number new sheets the sheet is protected, colourful as a display screen and contains command buttons

Hi, I'm trying to capture my dates, I'm using Hlookup but it always shows n/a. And my grid is kinda like this <tbody> Item Number Item Description ETA 01/01/17 01/05/18 21454 ABC1 2,115 1,222 21455 ABC2 0 3,008 </tbody> I want to capture the right date from the right...

Hi. I have two spreadsheets with results from som tests that I run. I The first spreadsheet may have extra rows that are not in the second sheet. The second sheet may have rows that aren’t in the first sheet. I would like to capture both these scenarios as well as capture differences in the...

Morning all, Im putting together a process which includes lots of screen shots but when I try to capture a filter in drop-down it disappears before I can capture the image. Is there a way of doing this? Thanks in advance. Stuart

I'm attempting to write a macro that will capture the values on the production sheet and disperse them onto the Rewinder Tracking sheet in the appropriate column/row. Capture from Production Sheet Cell Add to Existing totals on Tracking Sheet in Column F5...

I have a macro that is starting to get pretty intensive and beyond my knowledge base. Currently is takes the needed data from sheet(1) and copies it to a newly created "Sheet2" in a specific format. Once the macro is done formatting "Sheet2", it shows both userforms for the next part of this...

I use a "RTD" link to calculate a value. As the data changes over time, I want to save the Largest and the smallest value in another cell. Is there a simple way to record the largest or smallest value from the real time data? ...Replace if greater function?

Hello all, (Excel 2007 user) I have a spread sheet that has data dumped into one column. I need to assign each row of each page the corresponding Fund and Account number. There are keywords that can be used to search and capture. Each page has a keyword, lets say TopOfPage. The Fund number...

Hello, How do I capture the return value of a FIND function when the searched item cannot be found? I am trying to locate 'mystring' in various worksheets but the variable 'strCheck' is always 'True' & vbNullString is always "", so how do I correctly capture the value returned from the search...

l

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags"...