new column

  1. O

    VBA: Import every new data into a new column

    Hi all, in need of some help to import new data into new column. Currently, Ive only managed to import the data but with every new data, they are stacked below. I need them to be in a new column. Eg. data1 A2:B2, data2 D2:E2, etc... Also, is it possible to import the filename of the import data...
  2. R

    If cell is not empty then go to new line

    HI, I want call values from sheet1 to sheet2 but on sheet2 i have "Date, Description, amount" which i will enter manually but if i enter anything on sheet1 "date description, amount" it should reflect on sheet2, but it should post it on next new line Im trying this from last 2 days not able...
  3. N

    Need data arranged into columns when certain value is seen

    I have many items with bar codes on carts which also have bar codes. Every once in a while, I use a bar code scanner to scan what is on all of the carts. When I do this, the data is input in excel looking like this: B T1152567857 T1134567846 T1435678935 T1164536223 C T1678245534 T5674839298...
  4. E

    Help me !! - userform - update user info if frist,last name match

    im working on a userform that updatas the data if the person fist and last name is in on the sheet in column B&C. so what i would like to do is if the frist and last name match then it updates the row with textbox3,textbox4 ...ect then it textbox5 adds the "new info" the frist blank column...
  5. H

    Formatting one row into multiple rows with one identifier column

    Hello, So I have the results of a survey and the output given were <tbody> Name Prof Course Description Prof2 Course3 Description Prof5 Course6 Description Prof8 Course9 Description Prof11 Course12 Description Prof14 Course15 Description </tbody> Each row has the responses. However I need...
  6. A

    Macro to insert date and data into next available column

    Hi all I've tried searching the forums but with no success. I'm working on a macro which will basically pull in stock levels based upon the product code. I will use windows scheduler to open and run the macro on a daily basis. But I want the stock levels pulled into a new column and the...
  7. A

    how can i move my data from 1 column to another

    Hello, I new in VBA can anyone suggest me how can i move my data from 1 column to another. My column name is processor(is 5th column in excel) data starting from 7th Row having name and number together like akash21, deepak43, ravi12, Naveen13, and so on till 1156 row how can i move "only...

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