• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Transfer the data from different excel sheet to one

A

allrounder

New Member
I am preparing a price sheet where I want to create an order selection sheet.
I have multiple sheets which have some items and I want to perform selection in each sheet and transfer selected items to my order selection sheet.77353
 
allrounder
Based Your snapshot, it would be some challenges to offer anything useful for You.
...
but with a sample Excel-file, which has same layouts as Your normally used file - it would be possible.
 
vletm said:
allrounder
Based Your snapshot, it would be some challenges to offer anything useful for You.
...
but with a sample Excel-file, which has same layouts as Your normally used file - it would be possible.
Click to expand...

Hi, I did not find your sample sheet.
Also
I figured to make my solution simpler now.
Setp1: User press default button to make sure that the next person who will be using it will not make wrong entries. For this, I need a button in my main "select" sheet. Which will make all items (column B, F, M) =0 and delete all entries from the order selection sheet.
Step 2: Now instead of taking data from different sheets, I will take data only from my main sheet " select" and select the particular items column B, F, M and create the order selection sheet.
Step 3: The order Selection sheet will contain the description item and price.

Please find the attached reference sheet
 

Attachments

  • New Price Sheet-23-12-2021.xlsm
    217.9 KB · Views: 3
allrounder
About Your Hi, I did not find your sample sheet.
... it's You ( allrounder) who should able to upload a sample Excel-file ... as You had one.
... simpler ... means normally double work.

Why do Your sample file has so many sheets?
... four of those sheets would be enough ( one for those ... items ).
Why do Your Order Selection -sheet is almost empty?
... which should create after something ...
What would Your Refresh Here do? ... it would refresh what?
 
vletm said:
allrounder
About Your Hi, I did not find your sample sheet.
... it's You ( allrounder) who should able to upload a sample Excel-file ... as You had one.
... simpler ... means normally double work.--Agreed

Why do Your sample file has so many sheets?- It is because the user needs more information on a particular item. It only provides additional information to the user.
... four of those sheets would be enough ( one for those ... items ). Same as above
Why do Your Order Selection -sheet is almost empty? It is empty as I want only 3 options in it - Description, Item, and Price. So dose not matter at this time if i put them there or not.
... which should create after something ...
What would Your Refresh Here do? ... it would refresh what? It only refreshes the currency column from the setup sheet.
Click to expand...
Awaiting for your reply.
 
allrounder
Still many same layout sheets ... which could combine to one.
Empty Order Selection- sheet, which will create after something ... what to do with used Order Selection- sheet?
What would Your Refresh Here do? ... really.
> I also waited replies, which would help You from Friday.
Based those Your writings, I don't have that kind of image that I could follow Your written idea.
 
You must log in or register to reply here.
Back
Top