Search results

Hi, I have a file with data under different regions but similar categories, as follows Column B: Region name (50 regions), and more to be added sometime. Column C: Category name (36 identical categories per region) The data runs from Jan 2011 - Dec ("xxxx"), right now I have data up until...

Thanks ya'll, Hui's formula works excellent. -Injinia

Unfortunately, I have never uploaded a file before, I dont know how to do it. I will give it another shot, hopefully u get it clear now: 2 rows of data: B1:Z1 = Jan 11 to Dec 12 B2:Z2 = Figures for Sales at the end of the figures for sales, so (AA2; not Z3 as mentioned earlier) I would...

Hi, I have data running Jan 11 to current Jun 12. I have thus far being calculating the rolling month sum, manually. May data is as follows: B1:Z1 = Jan 11 to Dec 12 B2:Z2 = Figures for Sales In cell Z3, I have the rolling 12 month sum. If I update the cell with March sales, the rolling...

By the way, what does the "*38" in the formulas mean? -Injinia

SUCCESS!! Got it working. Thanks to all of you. cheers, injinia

Hi DR, Yo right, good thing is that I am learning and continuously improving my Excel skills :) I was trying to expand my validation to 39, don't know whether that has an effect on how the formula should work. Correct me if am wrong but you cannot use "," as a separator for the "IF"...

hi NARAYANK991, =IF($G41<>"";IF($B$1=1;'Areas'!F5;IF($B$1<39;OFFSET('Areas'!F5;($B$1-1)*38)));NA()) I input the above formula, pretty much what you gave me, unfortunately doesn't work. What would be wrong? -Injinia

How would I then write the "index formula" to shorten the one below...

Perfect! Thanks. -Injinia

Hi, I have a very long formula as shown below, it continues on to about 60 arguments. =IF($B$1=1;$C$2;IF($B$1=2;$C$3;IF($B$1=3;$C$4;IF($B$1=4;$C$5;IF($B$1=5;$C$6;IF($B$1=6;$C$7;IF($B$1=7;$C$8;IF($B$1=8;$C$9;IF($B$1=9;$C$10;IF($B$1=10;$C$11;IF($B$1=11;$C$12..... Is there a shorter way to...

Works Perfect! Thanks! -Injinia

Hi Faseeh That doesn't work because the text Town267 is not then copied to every row of data under it. The data looks something like this: Town:267 Exact Ops 200 300 Town:268 400 500 Carts Town:269 - - - so everytime there is town, the data under it should have that town name...

Hi, I have a set of data on one column. everytime new town data begins, the text Town:267 precedes the data and so on until the next Town 268. I would like these town names to be copied on the adjacent column next to the data so that I can filter it out if needed. Therefore, there would be...

Hi shrivallabha, Sorry I should have being more clear. The document is password protected by me!!! I am not asking for a hack :). I would like a macro that runs my password to unlock the sheet, have another macro run while the sheet is unlocked then runs again to lock the hidden sheet using my...

Hi, I have a macro that copies data from one sheet to another. These sheets are now hidden and the workbook/worksheet is protected. The macro now does not work as it supposed to. It runs(no error) but the data is not copied. I would need some help with a macro that unprotects the workbook...

Hi, I would like to put a password to a single sheet(name: "Sheet 2") on my workbook. I have a hyperlink on "Sheet 1" cell "G1". I would like to be prompted for a password to open sheet 2, every time I click on the hyperlink. Kindly help! -Injinia

works perfect! Thanks xld! -Injinia

Hi, I have a table with a date column on column B7:B13. I have tried using the formula =IF(H7<>"";TODAY();"") but the date updates whenever I open the table on a different date. How would I get the date to be set such that, whenever I input data into column H, column B on the same...

Thanks ya'll for the input. figured out how to do it from the discussion. Cheers, Injinia

Hi, What would be the problem with the following formula, doesn't return any result. =IF(C179="TRUE";SUMIF($E$178:$P$178;"x";E179:P179);"") -Injinia

Hi The macro below copies the first round of values, then on running it again it copies over the previously copied values. How do I get it to continuously copy the values & number formats to the next blank cell on column A in sheet 1, instead of copying over already existing data -Injinia...

Hi Luke Thanks for your help. However now the macro doesn't run as it should. It copies the first round of values, then on running it again it copies over the previously copied values. Could you help so that it continously copies the values & number formats to the next blank cell on column A...

Hi, How could I use the below macro to copy cells with formulas and paste them as values? Sub TransferData() Dim LastRow As Integer 'Where is the last cell with data? LastRow = Worksheets("Sheet 1").Range("A65536").End(xlUp).Row 'Transfer data Sheets("accuracy").Range("B23:L29").Copy...

Hi How could I use the above macro to copy cells with formulas and paste them as values? -Injinia