Use cells in different files IN excell

maryam1360, on Wednesday August 20, 2008 05:04:49 AM

Hello,
Hello,
H have different files named 110.xlc...1980.xlc...1020... and the final file there is a column in it . the value of it select as name of files 110...1020....
I want to selcet and set the value of rows from the file witch have same name first colum

eg
col1 col2 col3
110 (HERE cells in 110.xlc)
400 (HERE CELLS 400.XLC
300

regards
maryam

Configuration: Windows XP
Internet Explorer 6.0

Reply to maryam1360 Report this message to moderators Go to last message

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

crystal.me, on Wednesday August 20, 2008 10:49:06 AM

hi there,

i cant understand what you are trying to do but as far as i can understand cant you copy and paste the cells?

Reply to crystal.me

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

maryam1360, on Wednesday August 20, 2008 11:11:08 AM

Hi
there are more than 58 files and in each file 12 cells . if i use copy paste it takes more than 3 hours.
for your information ...
I want to collcet forms in excel in 58 branches (it contains statistics ) every week .
i use paste link for it...but it takes much time in large number...if you have better way ...say how ican do it.

thanks

Reply to maryam1360

Ask your question Reply

Results for

File player Hello, I am looking for a player that will play back AVI and 3GP Files. These are video that i took from my Motorola cell phone not quite sure why my cell took different file vidos! !. Windows media player does not play them!!. It would be great to... en.kioskea.net/forum/affich-4400-file-player

Download FxFoto FXFOTO is an administrator of pictures par excellence. Organize your photos automatically by acquisition. The program allows you to sail across the different files and to locate your photos faster for a quick visualization. Edit your photos to... en.kioskea.net/telecharger/telecharger-510-fxfoto

Linux - Tree structure of files In UNIX systems any element is represented in the form of a file. All files are architectured around a single tree structure where the base, called the root, is written "/". UNIX systems define different file types: Physical files, entered on the... en.kioskea.net/unix/unix-fichiers.php3

1 2 3 Next

Results for

Opening a PPS FILEOpening a PPS FILE PPS, acronym for PowerPoint Show, is a tool created by Microsoft Office PowerPoint for distinguished presentations and slideshows. PowerPoint enables you to draft your own presentation within different display and design... en.kioskea.net/faq/sujet-190-opening-a-pps-file

Keeping different versions of a Word document in the same fileMicrosoft Word calls this operation "versioning". The principle is very simple: one file will contain all the versions and will increase the file size. You can also extract any version and save it as a separate file/document. To use the version... en.kioskea.net/faq/sujet-12-keeping-different-versions-of-a-word-document-in-the-same-file

Video ConversionVideo Conversion Any Video Converter Total Video Converter Prism Video Converter With today’s technology, it is now possible to get various video formats. However, these files could each require a different audio player to be able... en.kioskea.net/faq/sujet-189-video-conversion

1 2 3 Next

Results for

Replace one sheet with anotherHello, How to replace one sheet with another sheet in different file, so that no link in the existing file become changed en.kioskea.net/forum/affich-27093-replace-one-sheet-with-another

Virus that changed my regestrisHello, yesterday my pc was struck by a virus that has changed my regestries of different files. for example my computer has changed to Ahsans computer, recycle bin has been changed to someother name and specially i does not alllow my home page to be... en.kioskea.net/forum/affich-30521-virus-that-changed-my-regestris

File server vs. SAN/NASHello, In the SMB market what are the technical differences between a high capacity file server and a SAN or NAS ? with disk capacity growing close to 1TB, what would it benefit to have a SAN or NAS in a small-to-medium business network infrastructure... en.kioskea.net/forum/affich-4995-file-server-vs-san-nas

1 2 3 Next

Results for

Download Instant File Name SearchAlthough mode searches already exist on Windows, sometimes more definite tools for specific tasks are needed. Instant Name Search Goes off search files by name on your computer or on a network instantly. It supports the Boolean operators (AND,or,... en.kioskea.net/telecharger/telecharger-630-instant-file-name-search

Download FileTypesManFilesTypesMan is an alternative in the thumb-index " Types of Files " in " Option of File " of Windows. It shows the list of extensions and types of files on your computer. For every extension, it shows this different information: the name of... en.kioskea.net/telecharger/telecharger-659-filetypesman

Download Harry's FiltersHarry's Filter is a Photoshop plugin containing more than 69 different effects for pictures. Harry's Filter allows you to choose the appropriate effect without having to juggle with menus and dialog boxes. The main effects are present appointed:... en.kioskea.net/telecharger/telecharger-1072-harry-s-filters

1 2 3 Next

Results for

US intelligence alerts travelers to cyber spiesThis 2006 file photo shows a Blackberry unit in Washinton, DC. A US intelligence office Friday warned Americans traveling to the Beijing Olympics or elsewhere to expect cyber spies to surreptitiously compromise their laptops, cellphones, and other... en.kioskea.net/actualites/us-intelligence-alerts-travelers-to-cyber-spies-10599-actualite.php3

1 2 3 Next

Results for

Video and digital imaging - Graphic filters Filtering consists in applying a transformation (called a filtre) to all or to part of a digital image by applying an operator. There are the following types of filters: Low-pass filters, which consist in attenuating image components with a high... en.kioskea.net/video/filtres.php3

Formatting a hard disk Before trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even... en.kioskea.net/repar/format.php3

Using FTP commands FTP (File Transfer Protocol) is a protocol — meaning a standard language that lets two machines communicate — used so that computers of different types (or with different operating systems) can transfer files over a network that uses... en.kioskea.net/utile/ftp.php3

1 2 3 Next