excel help

  1. P

    Display next and previous rows on userform

    Hi, I'm having a nightmare trying to find code to display (and edit if needed) the previous and next rows when using my userform. The userform is simple, includes 7 textbox and 1 combobox. I've managed to get the userform to populate the data sheet on the first blank row but can't figure out...
  2. C

    Holiday Entitlement Excel Doc

    HI, Am trying to make a holiday entitlement document for my business and need some help on the formulas as am rubbish on excel. I have found a excel doc on this site but cant get it to work. Start Date 25/03/2010 Staff Name Hol Year Start Hol Year End Accrual Start Date...
  3. B

    HELP!! Run Excel Macros IF..?

    Hi! I desperately need some help with some excel macros, can anybody help please? I need the VBA code so that an excel macros will run once automatically when, for example cell A4 = 1. I've managed to get this far with the VBA: Sub copytohere() If...
  4. B

    If cell is blank, fill in with cell above

    I have a list that was previously fully filled in, but I had to go through and insert many rows. Now with those inserted rows I want to insert the same text that is in the cell above. BQ5 - Anderson BQ6 - Anderson BQ7 - Anderson BQ8 - BQ9 - Anderson BQ10 - Anderson BQ11 - BQ12 - Rochester...
  5. J

    Continuously populating a list from a single cell input

    Currently I have a worksheet that employees record data obtained from testing. The data cosists of measurements of impurity levels in a specific substance. What I would like to happen is : The employee manually inputs a value into a cell. This value is then automatically added to a list that...
  6. B

    Replace cells if there is data to the right

    I have a spreadsheet of about 4000 rows. I have shipping box dimensions in 5 columns per box (L x W x H x Weight x Freight Class), with a total of 8 potential boxes. Columns AR - CE (40 columns) are split into the 8 groups. Box 1 :AR - AV Box 2: AW - BA Box 3: BB - BF ..... and so on. For some...
  7. B

    V-lookup formatting error

    In row A I have about 5000 SKUs that are generally a few numbers and then a few letters. For some reason, even though I go to "format as number", they all still have errors saying "Number Stored as Text". Because of this formatting error, the V-lookup doesn't return a value. But as soon as I...
  8. M

    Drop-down list exception

    I posted a thread earlier about a balance sheet and now I have another question. I have an expenses table that dispalys all the expenses that happened during a given year, the year is displayed on the formula as a reference to a cell that contains a drop down list where you pick the year. So...
  9. D

    how to use excel jeanie???

    I downloaded and used my excel jeanie and test it and i am stock on the clipboard part, where i can see my selected cell in internet explorer how can i use that in this forum??? Please Help me!!! Thank you in advance
  10. B

    No Idea What Function Or Formula Would Be Called?

    Hi Guys: Im trying to build a fairly basic calculator but I need to use 1 cell twice with 2 functions. Does that make any sense??? My problem lies in cell C8 Here are my formula's =SUM(D3/(A8*10)) This one is in C8 And this one uses C8 =SUM(C8*A8)*10 but is in D8 =SUM(D3/(A8*10)) gives me...
  11. M

    Please help with Excel

    Hello, first, I’m happy to be a new member of MrExcel. It's an honor to be here.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> For some reason, it's extremely difficult for me to understand Excel jargon.<o:p></o:p> I know it will take time to...
  12. M

    Excel Help Please!!!

    Hello, first, i'm happy to be a new member of MrExcel. It's an honor to be here. For some reason, it's extremely difficult for me to understand Excel jargon. I know it will take time to learn it but for me, i learn much better from experience than reading up on it. With that said, can someone...
  13. C

    Intricate Row Inserting Code needed

    I am creating a First Article report generator and I have Sheet 1 as the place where all the numbers are entered for Sheet 2 to compile accordingly. I need help with what I need to do to be able to Generate rows on Sheet 2 from Data in Sheet 1. _____________________________ SHEET 1 A1 is...
  14. N

    Help in sorting bar chart

    Hi there I am trying to do a bar chart that shows data by day of week. I'd like to days of the week to be in a specific order..howver Excel is putting it in a random order or I can only sort by the values by day. Is there a way to fix it so If I want it to be sunday, monday etc...it stays...
  15. P

    Keeping Pictures with Data when I filter

    Hey everyone, I am creating a database in Excel with about 1,000 commercial properties. With each property I have several different columns of information (sq ftage, lease space, property type, address, etc), I also have pictures of each property. I have each column so I can sort with what...
  16. M

    please help with making a table

    Hi, I need to make a table for every hour for 1 day. I need to a "treatment" cell and 24 "hours" cells in one row. Can someone, please help me make the cells smaller just in these rows without decreasing the cells above them. Thanks in advance. Mark
  17. A

    Reg Updation of details in a weekly calendar..using excel 2003

    Hi friends, My Query: I have an excel sheet which contains an weekly calendar i have radio buttons fr weeks(say week1,week2...week5) combo box for choosing month and year now for example if i enter particular data in a cell with date july 1st...i.e; 1st week ,july month...year 2009...
  18. E

    I need a strange and specific macro and excel formula! Anyone, who knows?

    Hi! I am creating a very interesting thesaurus (words and their synonyms) for a script that I am developing! Why I need excel, when it is in .php? Well, that's a good question! What I need for the .php script is this format: " A " => " B ", where A and B are the word (A) and its synonym...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top