Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Replacing data from one column to another

  Sabbir, on Thursday 9 October 2008 à 09:02:00
Hello,

Is anybody help me please? I need to move data from second column to first column only if there is any data in second column. More clearly speaking in column D I have integer data almost in all row, in column G there are some integer data in few row, what I need is to cut data from column G (if exists) then paste in column D in same row(overwrite). This is not replacing column G to column D fully, only there is any value in G then cut it and replace it in corresponding row of column D.

volume of data is huge so doing this manually takes long time. Can I do it using simple formula or Macro or VB code ?
Configuration: Windows XP
Internet Explorer 7.0
Reply to Sabbir  Report this message to moderators

Résultats pour Replacing data from one column to another

Permantly hiding a column in Excel Hello, I have an .xls sheet to email to a client and I do not want him to see one column - which containes my profit margin. I can hide this, but once emailed he can simply unhide the column and view. Is there any way that I can hide the column... en.kioskea.net/forum/affich-13594-permantly-hiding-a-column-in-excel
Combining more columns to single Hello, how can i merge two or more columns to one column? For ex. i need to combine column A, B, C and D and the result should be displayed in column E. Is there any way to do that? please help me en.kioskea.net/forum/affich-6060-combining-more-columns-to-single
Need help with simple Macro (Solved) Hello, I have an Excel worksheet with data in columns that I would like to move to rows. The data is in A1:AN1 - I would like to make it shwo in the worksheet in rows A1 thru A40. Do you have a macro that will do this? Thanks! en.kioskea.net/forum/affich-26033-need-help-with-simple-macro

Résultats pour Replacing data from one column to another

Replacing the battery of your motherboard (CMOS battery)Replacing the battery of your motherboard (CMOS battery) Topics Symptoms Replacement sequence Saving the BIOS data Identify the CMOS battery Removing the discharged battery Installing the new battery Verify the BIOS data and resetting... en.kioskea.net/faq/sujet-625-replacing-the-battery-of-your-motherboard-cmos-battery
Backup Outlook 2003 dataBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application... en.kioskea.net/faq/sujet-47-backup-outlook-2003-data
Uploading Large FilesUploading Large Files You have surely encountered various difficulties for sending files through e-mail due file limitation. You have found the elucidation to your trouble. There are several means to transfer files and data from one... en.kioskea.net/faq/sujet-188-uploading-large-files
1 2 3 Next

Résultats pour Replacing data from one column to another

Bulk pasting problem with mac excelHello, I have a formula which i want to paste into 10,000 cells at once. because they are cells 1 to 10,000 in one column so it is relatively easy to select all 10,000 of them. however, when I press the paste button, it only pastes into the first... en.kioskea.net/forum/affich-6057-bulk-pasting-problem-with-mac-excel
Search engine macroHello, On sheet4 i have lots of data in columns. And i'm interested in two of them: col. i and col. k. In column i i have code (12-13 char). And in column k i have count numbers. I need macro, that takes the code from sheet4(column i), searches... en.kioskea.net/forum/affich-27471-search-engine-macro
Excel questionHello, I have a stock list. I can obtain the list and items that need replacement and ones that do not but I do not want to print out the whole list every time.I only need the items printed that require replacement.Can you tell me how to do this please. en.kioskea.net/forum/affich-29618-excel-question
1 2 3 Next

Résultats pour Replacing data from one column to another

Download Advanced WordReplacerThe programs of treatment of texts as MS Word allows to replace words of a text without having to correct them one after another. But when it is necessary to replace the same words on several different applications, it is everything a task. Advanced... en.kioskea.net/telecharger/telecharger-697-advanced-wordreplacer
Download LoopBe1LoopBe1 is a software which serves for transferring data MIDI from a program to the other one thanks to your internal equipment. In reality, it's as if the sound MIDI produced by an application is acquired by another application as source.Program can... en.kioskea.net/telecharger/telecharger-818-loopbe1
Download Teleport ProTeleport Pro is a tool polyvalent to inhale one said of data Internet French. You can, after downloading, make your navigation on PC by being except connection. Teleport Pro can throw up to ten series of requests at the same time on simple sites or... en.kioskea.net/telecharger/telecharger-346-teleport-pro
1 2 3 Next

Résultats pour Replacing data from one column to another

SKorea's Hynix announces 'fastest' one-gigabit chipSouth Korean employees of the Hynix Semiconductor at a branch of the company in Seoul in 2007. Hynix Semiconductor said Sunday it has developed what it calls the fastest data-processing one-gigabit memory chip for cellphones and other mobile... en.kioskea.net/actualites/skorea-s-hynix-announces-fastest-one-gigabit-chip-10271-actualite.php3
GPS spreading from cars to mobile phonesNokia presents a new model N96 on show at the Mobile World Congress in Barcelona, February 12. After replacing paper maps for millions of drivers, GPS technology is now being put into mobile phones and was one of the most-hyped developments at this... en.kioskea.net/actualites/gps-spreading-from-cars-to-mobile-phones-10108-actualite.php3
GPS spreading from cars to mobile phonesNokia presents a new model N96 on show at the Mobile World Congress in Barcelona, February 12. After replacing paper maps for millions of drivers, GPS technology is now being put into mobile phones and was one of the most-hyped developments at this... en.kioskea.net/actualites/gps-spreading-from-cars-to-mobile-phones-10115-actualite.php3
1 2 3 Next

Résultats pour Replacing data from one column to another

Data transmission - Introduction The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to the type of data,... en.kioskea.net/transmission/transintro.php3
Data transmission - Cabling Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted pair Optical fibre... en.kioskea.net/transmission/transcabl.php3
Data transmission - Analogue transmission Analogue data transmission consists of sending information over a physical transmission medium in the form of a wave. Data is transmitted via a carrier wave, a simple wave whose only purpose is to transport data by modification of one of its... en.kioskea.net/transmission/transanalog.php3
1 2 3 Next