+ Reply to Thread
Results 1 to 2 of 2

Data entry, rearranging tables and adding new columns to table

  1. #1
    Registered User
    Join Date
    03-24-2017
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    1

    Data entry, rearranging tables and adding new columns to table

    Hi!

    I need to add alot of data in to a excel sheet without having to search the entire sheet to find where to type the data (will eventually be lots of data in it).I figured Forms might be a good solution if i manage to rearrange rows with data in to columns as shown in picture. Customized Forms with VBA could probably solve all my need but is too advanced for me. Is this doable? Speak out if something is unclear.


    PS! For learning purposes I would be glad if guideance on methods to solve this were provided and not the solutions itself.

    Thanks

    forumpost.png

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Data entry, rearranging tables and adding new columns to table

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Weird Problem Rearranging Order of Columns in Pivot Table
    By thenp in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-12-2016, 04:06 PM
  2. [SOLVED] Rearranging data to new table sizes?
    By jessisprague7 in forum Excel General
    Replies: 2
    Last Post: 08-24-2015, 12:29 PM
  3. rearranging data in the row to be in columns
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2013, 09:55 AM
  4. LOOKUP, data rearranging without pivot tables?
    By Hambone70 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2013, 02:23 PM
  5. Rearranging categorical data into two columns
    By petyaall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2013, 11:02 AM
  6. Adding and rearranging the exact data
    By kate.middleton1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2012, 02:04 AM
  7. Rearranging Data Set by a Table
    By mtrant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2008, 03:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1