Käynnissä

Data from multiple worksheets to a Single workbook

I have over 50 files with the same format and placement of columns & rows in a single folder. The data in all of them starts from A1. From all these files, I would like to get the data in B column with B2 and downwards data. Wherever, the cells in B2 is empty, data has to be taken from the adjacent C column cell. Then, I would like to take that data and place it in the new workbook as separate columns with TWO column space in between the imported columns in the new workbook with data starting from Row 2 onwards. On top of all the new columns taken from each workbook (i.e., in Row 1), I want the name of the file from which each of these columns has been taken. All of these data are basically scrips from Bombay Stock Exchange. Therefore, I want the Change% of all these scrips for that day to be taken from "STOCK" button in Excel 365 and place it in the FIRST Empty Column to the right hand side of the scrips. Then in Row 1 of the "FIRST Empty Column to the right hand side of the scrips", an "Average" function is to be executed to know the avg return from the particular column. Again, in the SECOND Empty Column, for each scrip in each column, I want the (52 week high-Current Price)/(52 Wk Hi) formula in percentage terms. I want the ability to customize the columns and other important factors taken for the data too. For eg, if I want Column D is to be taken instead of B, I should be able to do that. I have uploaded 3such files below for your reference.

Taidot: tiedonsyöttö, tietojenkäsittely, Microsoft Access, Visual Basic, Excel

Näytä lisää: data multiple excel file single file, excel data multiple worksheets, excel vba extract data multiple worksheets, excel summary sheet multiple worksheets, copy data from multiple worksheets into one, consolidate data from multiple worksheets in a single worksheet vba, combine multiple excel sheets into one sheet, how to pull data from multiple workbooks in excel, how to pull data from multiple worksheets in excel vba, combine multiple excel sheets into one sheet vba, how to consolidate data in excel from multiple worksheets, how to combine multiple workbooks to one workbook in excel, merge multiple excel files into one sheet, data sql server single multiple data entry, excel vba data multiple worksheets, export data multiple excel sheets single excel file vb net, grab data multiple worksheets locations excel, import data cell multiple worksheets, script pull data multiple excel worksheets, grab data multiple worksheets excel

Tietoa työnantajasta:
( 0 arvostelua ) Muvattupuzha, India

Projektin tunnus: #26854880

8 freelanceria on tarjonnut keskimäärin 1188₹ tähän työhön

chilbig310

helo sir i have expriacne 2-3 year in data entry .i am a data entry professinoal. i have great speed and i do work any mistakes . and i deliver our work very soon.

₹1050 INR 7 päivässä
(0 arvostelua)
0.0
ErnestQuaye

I'm intrested in taking this job. I certainly believe you are looking for one who will be able to do your task with accuracy and precision . I would be honoured if you let me handle it. Stay safe Thanks.

₹700 INR 7 päivässä
(0 arvostelua)
0.0
cooooljoy

I am well experienced about Excel Spread Sheet. So I think I can do good for [login to view URL] you want to give your project to me you do not have any loss.

₹1050 INR 5 päivässä
(0 arvostelua)
0.0
gaurang74

Please hire me I will perfectly complete your work on time you need.

₹1300 INR 4 päivässä
(0 arvostelua)
0.0
Ashrafhina656

If you hire your project for me. I will do it with 100%accuracy Relevant Skills and Experience Typing skills

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
₹1300 INR 1 päivässä
(0 arvostelua)
0.0
Anuragsolanki18

hii this is Anurag here and i want to do this work for my own needs and i can do this work professionaly and very sincerely if somebody give me any work to do then i do that work very sincerely and it becomes my duty t Lisää

₹1750 INR 5 päivässä
(0 arvostelua)
0.0
aprizallead

iam advanced in using ms excel, to process data, combine , sortir, filter & any need display data in excel. have a good knowledge in formulas & table design, i can do this project.

₹1050 INR 7 päivässä
(0 arvostelua)
0.0