starting

I have Peoples Names down A starting in Row 2 down to 10 and Product ID in Row 1 starting in B thru H. My Values are in B2:H10 SumProduct((Indirect("SHeet1!$A$2:$A$10")=A1)*(Indirect("SHeet1!$B$1:$H$1")=B1)*(Indirect("SHeet1!$B$2:$H$10")) Gives me an error What am I doing wrong? Thanks

Hello, I am looking a solution for filling a repeated sequential numbers that has 4 criteria 1- Fill Total Row "criteria in cell B1" 2- Starting number "criteria in cell B2" 3- Fill repeats sequence "criteria in cell B3" 4- Add in previous number "criteria in cell B4" Note: first fill...

Good afternoon/morning/evening everyone! I was hoping someone wouldn't mind helping me with a little code I've had trouble trying to find a working version of on the various forums and articles out there. I have a Macro that pastes clipboard data specifically to cell A9 on the current...

Hi, I need some help with VBA. In a sheet called "Transactions", I would like to extract data from column Y if the corresponding cell in Column Z says "Send Email". I would like to create a new list in a sheet called "Main" in column A (after the title; so starting at A2) where the extracted...

I have a problem with which I can't find a good solution. I can't code VBA per se, but I'm usually pretty neat at finding codes online and stitch them together to something that works for my intended use. I haven't found anything usefully for my current problem. Currently, I have a workbook...

Hi folks, I'm trying to create a macro that will allow the user to input newrows in a protected worksheet based on a starting point and a number ofrows. The newly entered rows will be copies of the row above where the new rows willbe entered. That row contains formulas which must copy with the...

I have been using this site for years and I just realized I've been a jerk and not officially thanked or liked any posts (I hadn't noticed the little icons for doing so). I had said thank you, but not used the buttons. My question is, would it be rude to go back through and thank or like all...

Hello All, I am attempting to create a Macro that updates the naming convention in a specific application. In this Macro I will have 1 column that lists account names starting with T001 and goes all the way to T100, in the application I will be using all accounts should be listed in the same...

I'm using Navision which only has a starting date in the tables. I have an exchange rates table as below I have a transaction line with the posting date 02-04-2015 where I need to add the exchange rate for this date. It is the first in below (6,9464) but how do I find this result with a Power...

Am having difficulty writing a batch file around the following TYPE Microsoft Office Excel 2007 Macro-Enabled Workbook LOCATION C:\Users\Peter\Documents\AllData\PVOutput files\Pvoutput solar alinta estimates FILE NAME 7XX ROI sheet FOR BILL starting 090318.xlsm” This is what I wrote Start /D...

Hi all, my formula in column D is not calculating correctly. I'm just dividing column A by B but its just copying the results from the first line when i drag the formula down. I feel like there is something simple that i need to do to fix it but cant figure out why it just starting doing this...

Hi there, first post here. I did not find a direct match to my question, please direct me to the appropriate post if necessary. I need to show the date of the first Monday for a specific number of weeks starting from a specific week from a specific year. Example : first Monday of every week...

i need vba coding for the work that i have to do on daily basis. i have values in 3 consecutive Columns in sheet1, let say Columns AR AS AT and 70 rows starting from AR2 AS2 AT2.(these Rows are variable some time 10 some time 70 or even 500). i need to to copy values from these columns and paste...

I have a sheet listing over 200 individuals and their balances. When I want to look at someone's balance with a name such as Wood I have to scroll down over 200 rows. Can I have box on one of the top rows where I can enter the starting letter and the sheet will automatically go to the first...

I have a workbook with 5 sheets. On sheet one (INSPECTION), I need the text from column G to populate another sheet if a "Y" is in corresponding row. So, if a "Y" is in D9:D308 I need the text from the corresponding cell in column G to populate sheet 3 (Immediate Action) starting with B3. If a...

Hi Guys, I have an issue that i can't seem to get my head around. I have a tool that i use to determine how many staff i require to open my restaurant. With the manager starting at 07:00. The tool adds the following for each staff member starting; 07:00 = 1 08:00 = 0.75 09:00 = 0.5 10:00 =...

Hi, I have a spreadsheet with dates on the column of the data I process. I would like to see the number of days starting from the date in a different column, please help Thanks, P

I am in the need of some help. What I have is a simple excel data set. 2 columns, Column A is Time of day in 24 hrs @ 15 min intervals, (A1:A96). Column B contains whole numbers, (4 digits with comma) that are entered at every corresponding 15 min interval in Column A. I am needing the Max...

In column A is a list of accounts formatted as text. In column B is values. How do I take a sum of the value in column B of all accounts in column A starting with 4, 5 or 7?