help me!

Hi! I'm not that good at doing macros but, if you are, that should be a child game! All I want is to have the datas from my inventory sheets to be copied into the corresponding sheets "To Order" or "In Stock" depending on the values enter in the other sheets,. If the numbers in column To...

Hello everybody, First of all I want to say that VBA/Macro is not my strongest point. Maybe someone have a couple minutes to help me :) I've 2 columns in Sheet1 (data base) whit text in first is names of keys i.e. A1,P14,M18 and in the second column I have where is the key. So I'm looking for...

I've been looking for a solution with no success. My workbook has been moved to Google Spreadsheets but for the most part, this should be a non-issue. I created a Google Form that automatically feeds results/data to a tab in my spreadsheet. Each "survey" completed fills a row on the sheet so...

<tbody> 1395 - 6.90 30.14 1394 6.17 - 30.15 1393 - - 30.16 1392 - - 30.17 1391 - 6.91 30.18 1390 - - 30.19 1389 - - 30.20 1388 6.18 6.92 30.21 1387 - - 30.22 1386 - - 30.23 1385 - 6.93 30.24 1384 - - 30.25 1383 - - 30.26 1382 6.19 6.94 30.27 1381 - - 30.28 1380 - -...

Hi, This should be a quick one for somebody but I can't figure out why this is happening. Here is the formula: =IF($C5>0,IF(COLUMNS($A:A) < ROWS($1:1),0,IF(COLUMNS($A:A) < 3+ROWS($1:1),IF(COLUMNS($A:A)+ROWS($1:1)=2*ROWS($1:1),0,'Unbalanced cost calculations'!B$50))),0) which I need to...

Hello! I've read the posts about VLOOKUP problems and no one seems to be having this problem, just similar. I am using a VLOOKUP function in excel 2013 and thought it was all going fantastically until I noted the results it was giving back weren't right. The problem is is that the function...

I'm sure for all of you its easy but I don't know how to simplify this formula: =IF('Personal Details'!AB58="female waxing", 'Personal Details'!B58, IF('Personal Details'!AB59="female waxing", 'Personal Details'!B59, IF('Personal Details'!AB60="Female Waxing", 'Personal Details'!B60,IF('Personal...

OK so I am having a problem. I have a program that populates a spreadsheet. I want to essentially summarize this information in a new sheet. I have 7 cells of information that can be changed and need to cross reference this on my summary and pull the correct information from the data sheet to...

Hi Experts This is my first post so apology if i have done any mistake while posting the thread. I am looking for an excel formula to get the result. Data is provided in below table There are 3 criteria based on which a single value needs to pick automatically. criteria 1 = value 1 variable...

I had the formula and things were working great until I saved over it all and now I have tried, unsuccessfully, to find the formula I used online again. I need help! I have a list of grants with different names. I need to count the number of times they appear between 9/1/2012 and 12/31/2012 in...