rec

Morning, I'm trying to record a value from a cell (4,5) As I've created macro buttons that increase and decrease the value, the overall plan is to have a limit on those buttons too, however i want to create a record Button for the time being, and try figure out the later myself. Script so...

Hi, I had a code which auto update time & date on Col E and last modified userid on col F. Possible to rec which is the last modified cell? <tbody> A B C D E F abc def ghi jkl 8/9/2019 5:03:51 PM C:\Users\TOM , update Cell A, B, C,D </tbody> Private Sub...

Hi all, I'm having trouble with something - I'm new to Power Query and although I've done a search for what I'm looking for, I'm not sure I'm using the right terminology so I may have missed an answered thread. I have query on a csv file that I'm connected to and I refresh the data daily. I...

Been working this issue for a while and haven't been able to solve it myself. I can two workbooks, Rent Rolls and Rent Rec. I have several Named columns on rent Rec to keep things simple. Here is the formula I use in Rent Rolls...

Hi With the help of this thread I created a complicated workbook for a charity to record daily transactions. They have asked me to add a sheet that has the following: The data runs from Column V to Colum FU and rows 4 to 15. The pattern is regular across the range: Week Rec Amount The VBA...

Hi Experts, I wrote below code in a form for my team. It's a simple 'open file - copy - paste' exercise but for some reason a bunch of users are getting these random Automation Errors. I believe it happens when two big files are opened. Some users fix this after a restart and I had one user...

Hi, I require a function which looks at a ID in a certain column and only compares values across respective rows for that ID: 1) Function looks at cells containing the same ID 2) Looks at which currency is first alphabetically and then if PAY or REC to determine the Buyer Issue I am having is...

I am combining data in several columns into one single column using this formula: =OFFSET($F$2:$F$509,MOD(ROW()-ROW(ColumnData1),ROWS($F$2:$F$509)),TRUNC((ROW()-ROW(ColumnData1))/ROWS($F$2:$F$509),0),1,1) Then I'm using this formula to ignore blank and zero cells, round the number and only look...

Hey guys, I have a form with a couple of ComboBoxes and one of them is being populated based on files in directories. It populates just fine but I am unable to select any value in R_Rec by clicking on it, only using arrow keys. I have found out that the line of code that's preventing me to...

Hi I have two tables in separate tabs within a spreadsheet. Table 1: 'EmpInfo' <tbody> A B C D E F 1 REC Start End WT/PT Last Updated Reason for Update 2 1 01/01/2010 02/02/2012 PT 02/02/2012 333 3 2 02/02/2012 17/06/2015 WT 17/06/2015 333 4 3 18/06/2015 24/01/2016 WT 24/01/2016...

Hi, I am having an issue with the below, the error I get is that the loop until function needs a do, but I can see that its there. Please let me know what I am missing/other mistakes with this. The idea is for all the rows in sheet 2, their value in column A to be compared to row B in sheet 1...