Re: Range of multiple cells with fixed columns.
Tyvm Chirayuw! it worked perfectly
thnkssss!
Re: Range of multiple cells with fixed columns.
Tyvm Chirayuw! it worked perfectly
thnkssss!
Hey guys!
I'm a total noob and I'm struggling with this... Any help would be much appreciated!
I'm trying to set a range of multiple cells where the rows are fetched from the .Selection property but the columns are fixed values (A_:H_).
In case I wasn't clear enough regarding what I'm trying to accomplish, here are some examples:
if my Selection range is (B1:D9), I need to get (A1:H9) range.
if my Selection range is (C1:P4), I need to get (A1:H4) range.
if my Selection range is (AA76:BD55), I need to get (A76:H55) range.
Every tip is much appreciated!
Cheers!
Re: 20 USD - Import data from several closed WB to a sheet in a new WB (matching IDs)
Sorry if what I wrote turned out rude or impolite, it wasn't my intention. I'm not very good at english.
Although I am in a hurry, I'm not asking you to have it ready in a time frame... I just wanted to know when you think you would be able to have it done, in order for me to plan things out accordingly.
I know $20 isn't much, and I would really appreciate if you reconsider doing this job for me.
I really need this, and I'm really sorry if my post bothered you.
Re: 20 USD - Import data from several closed WB to a sheet in a new WB (matching IDs)
forum.ozgrid.com/index.php?attachment/51383/
There it is.
Sorry about that, I thought I put the example in my first post.
That would be a simplified example of the excel i'll be working with.
The real ones from folder1 will have 6 sheets each that I'll need to merge into one into the result worksheet.
The real ones from folder2 and folder3 will have just one sheet each.
Hi guys, I'll try explaining what I need the best way I can, english is not my first language so please bear with me ;).
I already paid 2 USD to OzGrid: 31582452DY544813W , the 20 USD goes to whoever helps me here.
BACKGROUND:
I have around 150 Workbooks, with 3 differente templates, (like 100 workbooks from "template 1", 40 from "template 2", and 10 from "template 3"), and the only thing this three templates have in common its and ID number column. Now, what I need to do is to combine all this templates into a single sheet in a new workbook matching their ID number.
There's 3 folders and each one have several workbooks, every workbook from "folder1" have the exact same structure, as do the workbooks from "folder2" and "folder3". But, the structure and content of Workbooks from "folder 1" to "folder2", and "folder3" are completely different. (three types of workbooks, one in each folder).
The workbooks from "folder1" are the main workbooks and they have all the ID numbers that currently exists.
The workbooks from "folder2" and "folder3", were created by specialist by analyzing the data of a few registers (few IDs) from the workbooks of the "folder1", so wb from folder2 and folder3 just have SOME of the ID numbers, NOT ALL of them.
What I need can be summarize in two steps.
-First I need a script that merges all my main workbooks from "folder1" one below each other in a new workbook that I'll call Results.
-Secondly I need the script to be able to copy all the columns aside from the ID from the workbooks from folder1 and folder2 and paste them next to each other in the corresponding row that matches the ID.
On top of that, there is a possiblity that new workbooks may arrive with updated data from existing ID registers, so in the first part (merging every wb from folder1) I need the script to check if the ID already exists, and if it does I need it to update the register and not create one more row with the same ID with different data.
I'm uploading a WinRAR with a simplified example of how my workbooks and folders look like, and how I would like my new workbook "Results" to look once the scripts finishes.
forum.ozgrid.com/index.php?attachment/51384/
If u need more information, I'll be back in eight to ten more hours from now.
Oh and if possible I wish you could put comments on the script specifying what you did every step of the way, cause I'll have to edit it in the near future and I'm a complete noob.
Thank you very much!
Re: Import data from several closed Workbooks to a sheet in a new Workbook (matching
Dear Patel,
Thank you for your quick response.
First of all, I must say I'm really over my head with this task, so I'm sorry if I make dumb questions or comments.
I checked out your link, and used the third coding example (the one that merges one next to each other), and I noticed the code doesn't do what i want to.
The code did run but the new merged workbook only contained the ID numbers of every workbook instead of displaying the information related to that row's ID.
I mean, following my previous example (the one with the pictures at my first post), the code generated a new workbook that goes like this:
[ATTACH=CONFIG]51318[/ATTACH]
I'll try explaining what I need better this time.
I have 3 folders and each one have several workbooks, every workbook from "folder1" have the exact same structure, as do the workbooks from "folder2" and "folder3". But, the structure and content of Workbooks from "folder 1" to "folder2", and "folder3" are completely different. (three types of workbooks, one in each folder)
The workbooks from "folder1" are the main workbooks. These workbooks are records of about a thousand cows (where the columns are: ID number, weight, height, age, etc) (like 50 different atributes).
The workbooks from "folder2" and "folder3" are differents kind of workbooks created by different specialists that created new workbooks from SOME of the previous records of the workbooks from "folder1". (They DIDN'T use the records of every single cow from "folder1", they selected a few and made some new information with it)
So, the workbooks from "folder2" and "folder3" goes like this, columns: ID number, atribute1, atribute2, atribute3, etc. Where the ID number is the same as the ID Number from the main workbooks from "folder1".
So... just as an example:
wb from "folder1" have ID numbers that goes from 1 to 10 (1,2,3,4,5,6,7,8,9,10) (and a serie of other atributes) (whole universe of IDs)
wb from "folder2" have ID numbers (1,4,5,7,8) (and a serie of other atributes) (some IDs)
wb from "folder3" have ID numbers (1,2,3,6,8,10) (and a serie of other atributes) (some IDs)
Ok, so with that being said, what I need is a script that firstly merges all my main workbooks from "folder1" one below each other in a new workbook that I'll call MasterBook (I think the code u sended may work for this).
Secondly I need the script to be able to copy all the columns aside from the ID and paste them next to each other in the corresponding row that matches the ID.
Basically what I expect to have in the end is something like this...
[ATTACH=CONFIG]51321[/ATTACH]
Where the gray table is my masterbook that was created from my workbooks from folder1 (blue table), folder2 (orange table) and folder3 (green table).
I hope I'll get my point across.
Im sorry for any grammar error or synthesis, english isn't my first language and I'm not that good at it as you may see.
Thank you very much and sorry for the long post..
Hi all, first time posting in this forum. I'll try to be as concise and clear as I can.
I have around 150 Workbooks, with 3 differente templates, (like 100 workbooks from "template 1", 40 from "template 2", and 10 from "template 3"), and the only thing this three templates have in common its and ID number column. Now, what I need to do is to combine all this templates into a single sheet in a new workbook matching their ID number.
I have three folders with workbooks, one for each template, so I was thinking about a script that could open (but not actually pop up) all the workbooks from a selected folder (lets say folder1 that contains only template1 workbooks) and copy the values to a new workbook (lets name it Masterbook). Then I need to be able to open and copy all the workbooks from another folder (lets say folder2 that contains only template2 workbooks) and copy the values to the Masterbook matching the ID number thats already there from copying the values of template1 workbooks. Then the same thing applies for the folder3 with template3 workbooks.
Example:
[ATTACH=CONFIG]51313[/ATTACH]
Those would be the three different templates in wich only template1 have all existing IDs (remember I have several workbooks from each template).
[ATTACH=CONFIG]51314[/ATTACH]
And this would be the result I'd like to have with the script, the value from each workbook and each template copied in a single sheet matching by the ID number.
If anyone need further information, I'll be glad to provide it, or at least try to. haha.
Thanks a lot!
Cheers!