Search:

Type: Posts; User: abschy; Keyword(s):

Search: Search took 0.00 seconds.

  1. VBA for copy and paste between worksheets

    Hi all,

    I have a worksheet that has multiple sheets of data, and i want to consolidate the data into 1 page of unique values.

    I have this code written but want to shorten it by using some loops...
  2. Import data from excel on Sharepoint online into another excel on my com

    Hi all,

    I've been trying to figure this out for the longest time but havent managed any progress.

    I have an excel sheet (Excel A) that i update regularly (ie daily) that is put on my company's...
  3. Replies
    2
    Views
    214

    Re: Display text/words in pivot table

    Hi, that helped alot!

    However, my data is still joined in 1 row.. is there a way for my data to be separated into individual rows??

    Thanks!!
  4. Replies
    2
    Views
    214

    Display text/words in pivot table

    Hi i have a pivot table that i need to construct which has a mixture of words and numbers.

    Under the "Values" section of the pivot table, i have 8 columns of data, 2 of which i need to be shown as...
  5. Replies
    4
    Views
    347

    Re: 2 Digit Financial Year

    Hi Steve!

    That works great!!
    Thanks so much!
  6. Replies
    4
    Views
    347

    Re: 2 Digit Financial Year

    Hi, Thanks for your help!
    For me, my financial year starts 1st July as well!

    Is there any way for the outcome to be the later year?
    Currently it gives "18/19", but what I want is just "19" if...
  7. Replies
    4
    Views
    347

    2 Digit Financial Year

    Hi guys,


    Im having some difficulty formatting a 2 digit financial year.


    I currently have a column for the installation date --> which contains either just a month, or a specific date
    and a...
  8. Re: VBA - Loop for cell value to match worksheet name before copy and pasting

    Hi Dave,
    I managed to fix it already and it works great!
    Thanks so much!!!:)
  9. Printing/Saving a very wide excel sheet in PDF

    Hi guys,

    I have an excel sheet that is about 10 rows by 50 columns, so its very wide, but not long.
    Can someone advice me how to save this such that it doesnt look too small?
    I've tried breaking...
  10. Re: VBA - Loop for cell value to match worksheet name before copy and pasting

    Thanks Dave for your help!! It worked great!
    However, as my data is constantly growing, I need the data to be copied over every week or so - so the pasting should be done at the next empty row....
  11. VBA - Loop for cell value to match worksheet name before copy and pasting

    Hi guys, I'm a vba newbie and im currently having some issues writing out some vba code for this situation.

    So I have a
    1) Base worksheet which contains:
    My base data:
    Column B: different...
Results 1 to 11 of 11